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) //this controls how many tables show up on a row
{
//clear out all the table formatting stuff to start a new row of
tables
print ("<BR CLEAR=\"ALL\"><P> </P>\n"); //<P> creates a space
between the rows
$i=0; //resets $i for a new row
}
else
{
//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; //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
