How to export item SKUs during exporting daily orders

ken

Hi there,

We can find two SKU related fields when we build the template.
The one from Products/SKU has the correct data, but can't be exported with order data.
The other one from Order items/SKU just shows nothing.
Any idea?
Thanks!

Best regards,
Ken

japiera

Hi ken ,

The second one (Order items) is included for backward compatibility reasons. Old WooCommerce versions copied the product's SKU to an order item meta field when creating order items. That was discontinued, but we kept the field as said.

If you need to include the SKU field when exporting orders, please read this article in our knowledge base: https://stockmanagementlabs.crunch.help/en/tips-and-tricks/atum-export-code-snippet-to-add-the-product-s-sku-when-exporting-wc-orders

Best Regards,
José Andrés

ken

Hello José,

Thanks for your response.
I added those codes and tried again.
Now those products have variations have the correct SKUs exported.
However, if the product has no variation, the SKU value is still empty.
Any ideas?

Best regards,
Kenv

japiera

Hi ken ,

FYI, custom coding is out of the scope of our support.

The code in the article is provided as is. We don't provide support for it.

Anyway, in these lines should be the response:

$product_id = isset( $row['_variation_id'] ) ? $row['_variation_id'] : 0; if ( ! $product_id && isset( $row['_product_id'] ) ) { $product_id = $row['_product_id']; }

If the product in the order item is a variation, it should take the parent product ID. You should find out whether these fields exist in your database. No additional responses regarding this will be provided. I suggest contacting a good developer if you can't figure out where the problem is.

Best Regards,
José Andrés