Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2005
    Posts
    189
    Plugin Contributions
    0

    Default Shopping cart / order line item identity

    Hello,

    I am trying to connect zencart with another custom web program i am writing. I would like to permanently associate an item in the external program to each instance of a product, while the customer fills the shopping cart, and after an order was received and processed.

    Is there a unique identifier that identifies a line item in the shopping card "forever", i.e. also once an order is submitted and being processed, and then in then later in the history?

    For example:

    Suppose that the clients places 100 of product A, and 300 of product B, in her shopping cart. What I need is an identifier that uniquely idetifies:

    ID1: Line item 1 in potential order 001
    ID2: Line item 2 in potential order 001

    also

    ID3: Line item 1 in submitted order 001
    ID4: Line item 2 in submitted order 001



    Ideally, ID1==ID3 and ID2==ID4


    Does this information exist?


    appreciating your response,

    Daniel

    In the shopping cart we now have "potential order 1", line item 1, and line item 2.

  2. #2
    Join Date
    Sep 2005
    Posts
    189
    Plugin Contributions
    0

    Default Re: Shopping cart / order line item identity

    Hello,

    Some additional thoughts:

    While looking at the database i identify the following that seems relevant:

    tables:

    customers
    customers_basket
    customers_basket_attributes

    orders
    orders_products
    orders_products_attributes

    products
    products_attributse


    It appears to me that customer_basket might hold order information until an order is actually submitted. Once an order is completed it appears that data from customer_basket are duplicated (moved?) to orders_products etc.

    Is this correct?

    The above means that there is no common identifier for line items in the basket, and line items in a completed order ...

    thanks,

    daniel






    customers_basket_id
    customers_id
    products_id
    customers_basket_quantity
    final_price
    customers_basket_date_added

 

 

Similar Threads

  1. adding item to shopping cart takes me to item search page
    By knight74 in forum Templates, Stylesheets, Page Layout
    Replies: 3
    Last Post: 10 Aug 2010, 06:07 AM
  2. Is it possible to turn off shopping cart line that says "Weight"in Your Shopping Cart
    By Twaddle in forum Templates, Stylesheets, Page Layout
    Replies: 3
    Last Post: 22 Apr 2010, 06:34 AM
  3. Handling fee as seperate line item on order and invoice
    By conmac863 in forum Built-in Shipping and Payment Modules
    Replies: 0
    Last Post: 18 Jan 2009, 12:17 AM
  4. Line after each item in cart?
    By julieoolie in forum Templates, Stylesheets, Page Layout
    Replies: 10
    Last Post: 5 Feb 2008, 02:14 AM
  5. Order Subtotal does not match sum of line-item prices
    By beast666 in forum PayPal Express Checkout support
    Replies: 0
    Last Post: 5 Sep 2007, 09:19 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR