Total Posts: 9
This is my first post. We are about to embark on a Magento store for a front end. we already have backends and everything else.
It seems that when magento import doesn’t support the group/simple product relationship (it might but I can’t find any documentation) and I need to write my own. No a big deal except that Magento seems to assign entity_id’s to every product when added and also (and this is the part that really makes no sense to me) maintains the ids once an order is placed. THis means of course that if at anytime during the history of the store for some reason an entity_id on a product gets changed the order that the person thinks they ordered will also change. Is this true?? I’ve only just started looking at the order part of the DB.
Anyway we will be regularly uploading into the DB from our master backend DB and also downloading orders as they come in for fullfillment.
I can do this two ways: 1 use the SKU field to tie everything together. This will work but the SKU field isn’t set as unique. (I can either change the index or just not worry about it as my master DB has it unique already. of course this means tying everything to the SKU and doing a million queries every time I upload or download - but it will work. What I Don’t know is if the customer orders will continue to be accurate because even if I can sync up my products to a new SKU I’m not sure if the customer order history will reflect the original entity_id - which might change to a new product.
Another way of doing this is simply removing the auto_increment from the product_entity table entity_id and setting to my master id on my backend. I can easily enforce it’s uniqueness and suddenly the front end and back end talk the same language. THis of course means that all products must be added via the back end, which should be ok but I am wondering if there are products that MAgento adds to the product entity table automatically in the background? As I am typing this this latter solution seems far far better but I am curious about how order history is handled, automatic adding of products, and if I am missing something or if there is a better approach.