Shopping Cart

[Majortom]

Hi Guys,

Newbie to Caspio however I've created many Access Databases in the past (a while ago so slightly rusty!).  I'm trying to create an ecommerce database where a user selects items from a catalog (table in this case), goes into a shopping cart and then submits into an order.  Problem I've found with the sample databases (Simple order Management template for example) is each item goes in as a separate OrderID.  I want a user the select several items from a catalog which goes into a shopping cart and when they checkout all the items go under a single OrderID.

So at the end in the Orders table there is a single OrderID with all the items the user has selected under one record.

Are there any examples out there which would demonstrate this or anyone know the best way to go about architecting it?

 

Cheers,

MT

[kpcollier]

Hello @Majortom,

One way I can see you fixing this is by creating a new table for Placed Orders. You can set it up so each record has its own OrderID. Then, in your table design, keep adding fields for as many items you may think is your biggest order (this way there is a spot for each item for large orders, otherwise small orders will just leave some fields blank).

With this, you will be able to keep track of all Items by the OrderID (may want to change to ItemID or something similar) you have, as well as having an OrderID for each order that has been placed. Each record will have an OrderID with the fields being populated with the items they ordered.

 

[ManokNaPula]

Hi @Majortom,

 

As I understand, you wanted to see the lists of items ordered in a single ID.

You will be needing two tables for this, one table for order, and another on for the items.

On the "Item" table, you need the Item_ID and the Items (Item name)

And add the Items you wanted to post. 

 

After this, you will create the Order table. Set the items ordered as "List/String". Set the Value as a Lookup of the Item table.

 

And your table will look like this whenever an Order is added. 

 

Is this what you'll be needing? Let me know if this works.

 

Scarlet. 

[Majortom]

Thanks for the input guys.  I think I have solved the multi item issue (please see screenshot of the tables and relationships).  Problem I am having now is how to display it.  For example on Order ID 1, my user Dave has ordered 2 servers and one storage array.  I have combined the tables via a view then created a new data page (report) based off that view.

Problem I am seeing in the report (screenshot at the bottom) and probably a layout issue is its showing the storage array twice on each line as if they've ordered 2 when they have only ordered 1.

Ideally what I want the layout to show is something like this:

CustomerID : 1

Customer Name: Dave

Servers:

Qty: 2          Form Factor:  Rack          CPU Make:  AMD         No of CPU: 2

Qty: 1          Form Factor: Tower       CPU Make: Intel             No. of CPU: 1

Storage:

Qty: 1         Protocol: Block          Type: Hybrid           Capacity TB: 100

----------------------------------------------------------------------------------------------------------------------------------------------

 

Thanks for all your help.

MT