Thanks Kevin,
That will do the trick
as for POS - I'm using POSitive for windows. -- the price was right<g>.
They really intend on a person using this system with Epoxy web store
system, I have other plans...
It can CSV out just about anything
Department, Category, Item Description(long), Inventory
Description(short),price 1~ price 6, SKU, cost, Qty in stock, Qty
Ordered,etc...
The SKU's are random or reflect barcodes. - The Inventory descriptions are
like "p1-BLU-36-30", Long Descriptions are like "Traditional cotton work
pants"
I am currently using variations with single Items
A color variation, a waist variation, and an inseam variation.
Freetrade doesn't seem to allow a variation, or variation combo to have a
sku, besides the item skus or sub item sku's
I don't want my Item page to list 2000+ separate sku's for each Style of
pants in all colors, waists. and inseams. -- I'm trying to limit bandwidth
problems<g>
But rather have the sku reflect the variations automatically, i.e.. the sku
is generated by the variations selected.
Item sku is P1
Var 1 = BLU
Var 2 = 36
Var 3 = 30
Inventory Sku = Item Sku ~Var1~ Var 2~ Var3 "P1BLU3630"
But then I need to check inventory of P1BLU3630 after the customer submits
to cart.
I'd also like to check and respond to no selection. If a color or size is
not select, return to page and don't add to basket - prompt user of error.
That kind of thing.....
I'm pretty sure this can be done by wiping up some code in between the item
page and the add to cart function.- I learning, but I'm not far enough along
to even begin to figure out how.
Jeremy Taylor
----- Original Message -----
From: "Kevin" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, August 27, 2001 1:45 AM
Subject: Re: [FreeTrade-dev] New Store and Cheap Stuff
> go to the department screen. There are many ways to do this:
> a) generate a table for each item on the page
> b) or generate a table for each row on the page
> c) or generate a table that encompasses all the items on the page.
>
> I prefer the first two. The following code is for option a
>
> Look for this line, it appears twice - once for departments and again for
> items:
>
> while($DatabaseRow = mysql_fetch_object($DatabaseResult))
>
> start a counting variable such as $i
>
> $i=0;
> while($DatabaseRow = mysql_fetch_object($DatabaseResult))
>
>
> put a table around your department and then your item display code
>
> after you close the table out but before the end of the item or department
> while loop do a:
>
> if($i==2) file://this controls how many tables show up on a row
> {
> file://clear out all the table formatting stuff to start a new row
of
> tables
> print ("<BR CLEAR=\"ALL\"><P> </P>\n"); file://<P> creates a
space
> between the rows
> $i=0; file://resets $i for a new row
> }
> else
> {
> file://print a dummy table aligned left so the next item or
department is
> displayed in the same row
> print("<TABLE
> ALIGN=\"LEFT\"><TR><TD> </TD></TR></TABLE>\n");
> ++$i; file://increments $i 1
> }
>
> }// end of the while loop
>
> That should do it. You have to do this for the department loop and then
for
> the item loop.
>
> Hope it helps.
>
> As for your store, I would probably start at your POS system. If you can
> export a csv file that's half the battle. I have a few questions though.
>
> If you can export from your POS system to a csv file, can you control the
> formatting?
> How are items stored in your POS system - is each item / variant have a
> unique sku - it probably does
>
> If the the above is true, creating what you want would be a piece of cake
as
> FT is set up to handle this out of the box - so to speak.
>
> Look at how items are linked to SKUs and how SKUs are stored in the db and
> how attributes are linked to each SKU. It seems to me that writing a php
> script to read the csv file and make the appropriate entries would be
pretty
> easy.
>
> Give the list some more info. I am sure someone has done this. I looked
at
> it for a client but it was cost prohibitive because thier POS system would
> have had to have been customized.
>
> Hope all this helps. Thanks for the comments on the store. Gotta love
Free
> Trade.
>
>
> ----- Original Message -----
> From: Jeremy Taylor <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Sunday, August 26, 2001 10:25 PM
> Subject: Re: [FreeTrade-dev] New Store and Cheap Stuff
>
>
> Greetings
> Kevin - I really like what you did with your site
> I still a beginner at this - and one thing I want that I haven't
figured
> out how to do
> is tile the Item menus like you are doing on your site.
> 1,2,3
> instead of
> 1
> 2
> 3
> Could you offer me some code suggestions
>
> The other thing that bothers me, so much in fact that I've been avoiding
> it-is
> Variations, and Sku's and Prices.
> For instance - I carry a line of used work apparel available in any waist
> from 27-70 and inseams of 27-36. Any combination in this matrix is a
> separate SKU with separate inventory quantity. On top of that we have
Color
> (7 choices) That's 2709 different Skus for basically the same "item"
> I'd love to have the inventory on the site be accurate - but I've settled
> for requiring email conformations of stock available - from our POS
system.-
> Through invoice csv magic.
>
> I'd love to just import All skus with descriptions and quantity in to
> freetrade.
> But I cant quite understand the flow - or how many db tables I'd need to
> tweak to auto format the Sku.and Items in the proper location ( Under a
pre
> existing "item")
>
> What should I do about this????
>
>
> Jeremy Taylor
>
> ----- Original Message -----
> From: "Kevin" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Sunday, August 26, 2001 11:48 PM
> Subject: [FreeTrade-dev] New Store and Cheap Stuff
>
>
> > http://www.ldigitaldesign.com/go/view/department
> >
> > I have some computer products left over from my eBay auction days, so I
> > created a store to get rid of it. This store/site is Free Trade 1.4 and
> > uses the url parsing stuff offered by Ron Dyck. Also, it won't shoot a
> sid
> > into the url (provided your cookies are turned off) until you add a
> product
> > to your basket or log in. Very search engine friendly.
> >
> > So, check out the store and let me know what you think. Feedback is
> always
> > good.
> >
> > ***If any of you FT'ers see anything you like, I'll ship it to you with
no
> > extra charges for shipping - Cont. US only.
> >
> > The products are marked down way below what I paid for them. Some are
> > customer returns. Most products are refurbished. Just haven't had time
> to
> > get rid of them. They are warranted for 30 days.
> >
> > You'll have to pay with paypal or send me a check as I don't have a
> merchant
> > account set up for things like this.
> >
> > Kevin
> >
> >
>
>
>
> _______________________________________________
> FreeTrade-dev mailing list
> [EMAIL PROTECTED]
> http://share.whichever.com/mailman/listinfo/freetrade-dev
>
_______________________________________________
FreeTrade-dev mailing list
[EMAIL PROTECTED]
http://share.whichever.com/mailman/listinfo/freetrade-dev
