Hi, GenesisHoldings
First of all, thank you for your interest in our plugins.
Unfortunately, what you want is not possible at this time with ATUM Export. The Orders entity is not related to the Products entity ( and you need it to get the Supplier SKU) for various reasons: to keep the UI as clean and simple as possible, for performance reasons, and the principal, you need more than a SQL sentence to get this data (when the product sold is simple, the relation with the item is given by the product_id but if it's a variation, the field would be variation_id).
Anyway, if you want to get this field in your export, you need some custom code. I see two approaches to achieve this:
- You can use one of our hooks to include the Products entity as a relation for the Orders entity. I can give you some hints on this as a part of our premium support once you have an active license. Please, understand that this doesn't include coding support, only to give some hints to make the task easier.
- You can add the supplier's SKU as a meta field to the order's item when creating it (for example, using the hook woocommerce_add_order_item_meta). From the moment the field is present in the database, ATUM Export will be able to include it in your custom templates.
Hope this helps.
José Andrés