It seems that Datagrab is leaving out several columns of data (lives in exp_cartthrob_order_items table) that CartThrob needs for an order entry: price_plus_tax, site_id, entry_date, discount & item_number.
I honestly don’t know if that was an issue in old Datagrab or not as I hadn’t needed to do these type of imports before. Only six things are asking to be mapped for that section, none of which are the missing fields, and two of them aren’t even in our actual ‘Store - Orders’ entries - those are ‘modifier’ and ‘size’. I left these blank as we do not use these fields, if they still exist in CT, but it still tried to add them into the order-item line of the order entry.
The last two fields may be unique to our build, and as such may be stored in the ‘extra’ column in the exp_cartthrob_order_items table as some sort of string.
The primary issue here is that CT requires that those first mentioned fields not be null, so we end up with SQL/PHP errors when trying to save the entry. I’m not sure what other unforeseen issues it could cause with those fields missing.
Additionally, it seems only single line items are being imported to the order entry. For example, there are several orders that have more than one different item, but the import only picks the _last_ one it sees.
The staging server has an import set up for testing purposes named ‘orders with items’; it’s already pulled in all of the latest orders as of 12/13, but I am sure there have been more since that date I can extract from the production server and create a new CSV if necessary.