Populating zen cart shopping cart from a script

Hi,

I'm trying to populate the zen cart shopping cart from a script in a client installed program.

I will be posting to a url script (written by me) and then use this script to populate set items into the cart.

The user will then be be prompted to log on or register, then proceed to Checkout.

the problem is I cant find where these items are stored? Where does the shopping cart reside? Which table?

I'm using Zencart 1.3.9 on LINUX/apache server.

thanks in advance.

No one got any ideas???

I cant find where these items are stored?

Where does the shopping cart reside? Which table?
They are only temporary until ordered, then they are in the orders table

Not sure what you are attempting from your description

So a better detailed description might be in order

Basically I have a client-installed application which can post to a url and order supplies from my shop.

so the post url could be....

http://www.myshop.com/populate_cart.php?item1=101&item2=32&item3=50

So I want to write my script populate_cart.php to handle adding items into the cart.

Now, I know that you dont need to be logged on to Zen Cart to add items to your shopping cart, but what I need to know is where the items are actually stored?

I thought it was in the orders_products table but it appears not.

Can anyone help? there must be a table somewhere that stores this data, since it cant be stored in a cookie, too small!

Any help appreciated.

what I need to know is where the items are actually stored?
If you mean products then they are in the 'products" table

If not then again expand on what your are actually referring to...

what I mean is, where are the shopping cart items stored when you add an item to the cart?

Normally it's the orders_products table, if you're logged on.

But if you're NOT logged on, where are they stored? There must be another "non-authenticated" cart somewhere? ie some kind of session cart which stores the items to your cart as you add them.

thanks

where are the shopping cart items stored when you add an item to the cart
These are the tables where a logged in customers added items are saved if purchase is not completed

customers_basket
and
customers_basket_attributes

Items just added to a cart are not stored in the database but in session variables.

Ah!
thank you!

I suspected this, since I did more tests and found that the customers_basket table was empty after adding items to the cart.

So how would I add items to the session with a script then?

Presumably there's already a Zen Cart module which handles this?
Can someone point me in the right direction?

thanks!

webcomsystems:

I suspected this, since I did more tests and found that the customers_basket table was empty after adding items to the cart.
=gjh42Items just added to a cart are not stored in the database but in session variables.
Note the "just" referenced....that means logged in or not they are stored in a session variable
If a not logged in shopper leaves these are not maintained anywhere as the session expires

If you are logging in and adding to your cart without completing the purchase, then you should be seeing them in the table I referenced.
You must be logged in for this to be saved in the table

Thanks,

but in the majority of cases the customer will not be logged on to Zen Cart.

Therefore, I need to create a script that will handle the POST from my client app and populate the session variables with this data.

In other words, the client app will have shop items with their corresponding quantities POSTed to the Zen Cart, then the session cart will be populated with this.

Then the customer logs on (or registers) to go to the Checkout.

So, I need to know which Zen cart script handles the population of products_id and customers_basket_quantity into the session?

In other words, the client app will have shop items with their corresponding quantities POSTed to the Zen Cart, then the session cart will be populated with this.

Then the customer logs on (or registers) to go to the Checkout.
ZenCart already handles this without the need for an additional script

Yes, I know.

but where is the script that does this?

I need to see it so that I can interface with it with my own handler from my client app.