We use the “Advanced Order Export For WooCommerce” plugin that feeds into a backend system.
We need to be able to add product codes for any options (not visible to the user if we can avoid it), so that when exporting, we can see the product code for selected PPOM fields. We have tried using the “Unique ID” field for product codes but that’s stored as serialized data in the DB which is far too complex to work with.
We use Advanced Order Export For WooCommerce to export orders.
The orders are then fed into a system for stock inventory and dropshipping.
The PPOM fields contain products, such as tick box to add cables, plugs, etc.
We need a way to add product codes to those fields. Currently when exporting, we see the field label (such as “Add 5M USB cable”), however we need the product code of a 5M USB Cable when exporting.
I’m requesting for an additional field to be added to allow for a product ID to be added (so you have label, price, weight, Unique ID, Product ID) that can be easily accessed from the database in the order_itemmeta table.