Model or SKU ??

[nigelt]

Can anyone tell me why the order_products table holds MODEL but not SKU ??

I'm extracting order information to feed into my standalone inventory system, which is keyed on SKU.

I'd have thought SKU would have been better to store than Model.

Thanks
(apologies for all the posts with questions)

[llegrand]

It would be nice to have both included in the order_products table.   Perhaps Abantecart will consider adding that.

In the meantime you could construct a lookup table on your end of the data and add your SKU that way.  It adds one step to your process but it would probably have you much time in picking your orders.

the cross reference as keyed into your cart database is in table Products,   Fields are model  and  sku
Lee

[nigelt]

Thanks Lee, I'll do it that way.
I'm coming from Magento and I bloomin' love Abantecart :-)