altering basket contents

i noticed the products_id in the customers_basket tables can either be stored as the real products_id say 123 or as 123:a2345erttetcetera.
What i make from it, probably zen_id's get stored along with the products_id into this products_id field when someone is logged in as opposed to someone not being logged in?

Is there a reason for that behaviour, is it expected?
I would prefer just the products_id would be listed and not the extended string so i can do normal searches on this column based on the products_id.

Thanks,
Jeroen

The "long string" is the product's attributes in a hash code. So you can't just "not have it":

Kim:

The "long string" is the product's attributes in a hash code. So you can't just "not have it":
Ah, i see, thanks

This is just a trick to convert the products_id from a products_id with a prid to just the products_id ...

Try this in phpMyAdmin ... there are better ways but this is a quick method I have used when I forget other ways ... :smile:
SELECT customers_basket_id, customers_id, products_id, customers_basket_quantity, final_price, customers_basket_date_added, products_id*1 as prod_id FROM customers_basket WHERE 1```

The prod_id will be created with the products_id without the prid attached ...

To do a search on a products_id without the prid, you could search using the Like %...% with **133:** to find products_id **133** ...

Ajeh:

This is just a trick to convert the products_id from a products_id with a prid to just the products_id ...

Try this in phpMyAdmin ... there are better ways but this is a quick method I have used when I forget other ways ... :smile:
SELECT customers_basket_id, customers_id, products_id, customers_basket_quantity, final_price, customers_basket_date_added, products_id*1 as prod_id FROM customers_basket WHERE 1
Hello Linda,
I really like it, works great, although i can't get my head around the logic behind it :smartalec: The column is tiny text field so if you multiply it by 1 it will disregard anything behind the : because it thinks this is some sort of decimal value...

Mmm, probably not, but i never understand how those magicians out there get the rabbits out of their hat either:laugh:

Nice trick, cheers,
Jeroen

One note on the use of the LIKE and the prid in the SQL statement ... you really want LIKE command with just the trailing %, example:

SELECT * FROM customers_basket WHERE products_id LIKE '133:%';

to avoid the issue of getting things like:
133
1133
2133
etc. etc. etc.

from being included in the match ...

Why is this done with hash code? In zen_orders_products and zen_orders_products_attributes, the orders_products_Id is used to link the two tables to save the attributes for the orders and products with attributes. It seems like a much better way. We already have the zen_customers_basket_attributes table.

Any thoughts?

The products_id in the basket is the prid that matches the orders_products table products_prid ...

There isn't a real need to store in the basket both a clean products_id and the prid ...

In the orders tables it is more efficient to have both as more things are done with those tables where having both are a better method ...