The 'Export data' functionality works well but I'm a bit confused as to why CS-Cart has separated the export of order data (eg. shipping details, customer name) from the order items.
My company supplies a daily batch of orders in the form of a spreadsheet, which contains all the shipping information, name, and products purchased. This is so our fulfillment company can feed the data into their automated fulfillment system. I believe this is commonplace.
However, the way the 'Export data' functionality is set up, we have to export two separate files (order items and order details) and merge columns together so we have one final spreadsheet that contains all the necessary information about a customer's order.
On top of that, if a customer orders more than one product, each purchased item will be exported as a separate row (when exporting order items). This is inconsistent behavior since each exported data belonging to a customer is separated by columns (when exporting order details). This leads to a lot of manual work which makes exporting data a real pain in the ass.
I would like to ask if the following is possible or if somebody has an add-on that does the following:
- Have one export that will export both the order details AND the order items into one single CSV file.
- When exporting the order items, list ALL of the store's products in columns with the product name in the header row. The data in the rows under these columns would be the quantity purchased of said product.
So, I would have the exported header row as something like this:
| Customer Name | Shipping Address | Product 1 | Product 2 | Product 3 |
If there is the value '2' under 'Product 1' then that means the customer has purchased 2 qty of 'Product 1'.
Does something like this exist now?
PS: Sorry for the long post. I wanted to make sure I was absolutely clear.