I have a CSV file of orders that needs to be converted to a specific labeling format and then saved as a new CSV file. The CSV includes a top row with a heading name in each column. I need to make specific replacements in the 'Item Name' and 'Item Variant' fields, which should then be renamed, along with other specific fields.

Here are the replacements that need to be made:


For each 'Item Name' and 'Item Variant' pair, perform the following replacements:

1. [Item Name: "White Mug", Item Variants: ["11oz",]] to ["123456789", ["987654321",]]

...

Please note:

Each 'Item Variant' in a pair should be replaced with the corresponding 'New Variant ID' in the same order.

If an 'Item Name' does not have any associated 'Item Variant', the 'Variant ID' field should be left blank.

The same 'Item Variant' can be associated with different 'Item Name's. Therefore, when replacing 'Item Variant' values, it is important to first check the 'Item Name' associated with it to determine the correct replacement value.

After these specific replacements have been made, please rename the columns as follows:

Rename "Order Id" to "Order ID"
Rename "Item Name" to "Product ID"
Rename "Item Variant" to "Variant ID"
Rename "Item Quantity" to "Quantity"
Rename "Customer Name" to "Full name"
Rename "Shipping Company Name" to "Company (optional)"
Rename "Shipping Address" to "Address line 1"
Rename "Shipping Address 2" to "Address line 2"
Rename "Shipping Country" to "Country"
Rename "Shipping State" to "State/Province/Prefecture"
Rename "Shipping City" to "City"
Rename "Shipping Zip" to "Postal/Zip code"
Rename "Shipping Phone" to "Phone (optional)"
Any columns not listed here should be left as they are.

The output CSV file should maintain the same row and column structure as the input file, except for the specified replacements and renamings. Please perform these conversions and provide me with the new CSV file.