Hi Experts!
I have an order export from my store producing a CSV file with set columns that I cannot change prior to the export (ORDER_EXPORT)
My warehouse requires a csv file in order to receive the orders with a different set of columns (headers and order of the data) (SHIPPER_CSV)
What I would need is a script that:
1. map the headers correctly (e.g. Shipping Name > recipient_name)
2. imports the data from ORDER_EXPORT to the correct SHIPPER_CSV columns
3. if ORDER_EXPORT header "Shipping Company" is not blank then SHIPPER_CSV "recipient_type" = B else SHIPPER_CSV "recipient_type" = C
3. saves SHIPPER_CSV as a .csv that can be imported
I have dabbled a little in VBA but it was a long time ago. Moreover i am not familiar with CSV and it's text strings instead of ranges...
Help please!
PS - below is the mapping I did of the headers for reference.
<tbody>
</tbody>
I have an order export from my store producing a CSV file with set columns that I cannot change prior to the export (ORDER_EXPORT)
My warehouse requires a csv file in order to receive the orders with a different set of columns (headers and order of the data) (SHIPPER_CSV)
What I would need is a script that:
1. map the headers correctly (e.g. Shipping Name > recipient_name)
2. imports the data from ORDER_EXPORT to the correct SHIPPER_CSV columns
3. if ORDER_EXPORT header "Shipping Company" is not blank then SHIPPER_CSV "recipient_type" = B else SHIPPER_CSV "recipient_type" = C
3. saves SHIPPER_CSV as a .csv that can be imported
I have dabbled a little in VBA but it was a long time ago. Moreover i am not familiar with CSV and it's text strings instead of ranges...
Help please!
PS - below is the mapping I did of the headers for reference.
| ORDER_EXPORT | SHIPPER_CSV |
| Name | |
| Email | |
| Financial Status | |
| Paid at | |
| Fulfillment Status | |
| Fulfilled at | |
| Accepts Marketing | |
| Currency | |
| Subtotal | |
| Shipping | |
| Taxes | |
| Total | |
| Discount Code | |
| Discount Amount | |
| Shipping Method | |
| Created at | |
| Lineitem quantity | |
| Lineitem name | |
| Lineitem price | |
| Lineitem compare at price | |
| Lineitem sku | |
| Lineitem requires shipping | |
| Lineitem taxable | |
| Lineitem fulfillment status | |
| Billing Name | |
| Billing Street | |
| Billing Address1 | |
| Billing Address2 | |
| Billing Company | |
| Billing City | |
| Billing Zip | |
| Billing Province | |
| Billing Country | |
| Billing Phone | |
| Shipping Name | recipient_name |
| Shipping Street | recipient_street1 |
| Shipping Address1 | recipient_house_no |
| Shipping Address2 | recipient_street2 |
| Shipping Company | recipient_name2 |
| Shipping City | recipient_city |
| Shipping Zip | recipient_zip |
| Shipping Province | recipient_state |
| Shipping Country | recipient_country |
| Shipping Phone | recipient_phone |
| Notes | recipient_comment |
| Note Attributes | |
| Cancelled at | |
| Payment Method | |
| Payment Reference | |
| Refunded Amount | |
| Vendor | |
| Id | |
| Tags | |
| Risk Level | |
| Source | |
| Lineitem discount | |
| Tax 1 Name | |
| Tax 1 Value | |
| Tax 2 Name | |
| Tax 2 Value | |
| Tax 3 Name | |
| Tax 3 Value | |
| Tax 4 Name | |
| Tax 4 Value | |
| Tax 5 Name | |
| Tax 5 Value | |
| Phone | |
| recipient_language_code | |
| recipient_fax | |
| recipient_type |
<tbody>
</tbody>
