PDA

View Full Version : My turn to ask questions!


WebCzar
July 28th, 2003, 03:47 PM
I am looking for a shopping cart to add to an existing site. The site now is like a catalog. I already have over 600 items in the database, complete with descriptions and everything.

How hard is it going to be for me to import all my data into your databases? My inventory table has 23 fields. It took me weeks to get all this stuff in here... I really do NOT want to have to go thru all that again.

Is it possible to just add a <Add to Cart> button to my current display? This site JUST went online... you know how bosses are... we were not going to add a cart for a year... oh well... haha

Basically I want to know if, by using your product, how much work I am going to have to do to keep the site looking the way it looks now. You can see the layout here (http://www.cowboymaloney.com)

Jamie
July 28th, 2003, 04:06 PM
Hi Mike,

Thanks for checking us out.

> How hard is it going to be for me to import all my data into your
> databases? My inventory table has 23 fields. It took me weeks to get
> all this stuff in here... I really do NOT want to have to go thru all that > again.

It is a little tricky, but can be done. We have no support built into the cart for importing data. You need to generate a text file containing 1 MySQL query for each product, and one for each product / category relationship. Then, import the text file into your database using phpMyAdmin. This post shows the syntax for inserting one product:
http://www.ldev.com/forums/showpost.php?p=2824&postcount=2

This post shows the syntax for inserting a product into a category:
http://www.ldev.com/forums/showthread.php?t=431&highlight=import

> Is it possible to just add a <Add to Cart> button to my current display?

Yes. Please see this post for more info: http://www.ldev.com/forums/showthread.php?t=233.

> Basically I want to know if, by using your product, how much work I
> am going to have to do to keep the site looking the way it looks now.

It shouldn't be difficult to match that layout. Please see the install docs for more info:
http://squirrelcart.com/docs.

Thanks,
Jamie

WebCzar
July 28th, 2003, 04:44 PM
Hi Mike,

Thanks for checking us out.

<lots chopped out>

It shouldn't be difficult to match that layout. Please see the install docs for more info:
http://squirrelcart.com/docs.

Thanks,
Jamie

Ummm... one more question... my images are named by the ID number in my database. Is this still gonna work? On upload, my script creates thumbs, mid sized and full size images. If Squirrelcart works the same, and I can import them with the same ID number, I'll be recommending this to the people with the cash...

Jamie
July 28th, 2003, 04:52 PM
Hi,

Squirrelcart doesn't care what the name of the image file is, as long as all the image names are unique. If the folder you keep your images in is named "images" and is in your web root, then the path to an image file for a product would be:

products/image_name.jpg

BTW - The cart does not resize images, bit will in the future.

Thanks,
Jamie