AbanteCart Community

Shopping Cart Operations => Support => Topic started by: nigelt on April 09, 2014, 10:54:05 AM

Title: Model or SKU ??
Post by: nigelt on April 09, 2014, 10:54:05 AM

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)

Title: Re: Model or SKU ??
Post by: llegrand on April 09, 2014, 11:13:37 AM

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

Title: Re: Model or SKU ??
Post by: nigelt on April 09, 2014, 11:28:55 AM

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