Replace Product in Existing Orders
Update the SKU of existing order items when a product is changed or modified on Shopify.
This action is restricted to Merchandising managers.
MDM stands for Master Data Manager.
EXIM stands for Export Import.
To update the SKU of existing order items with new items:
Navigate to: Hamburger Menu > MDM > EXIM > Imports > Order management > Replace Order Item Product.
Download the sample template CSV and fill it out with the required details.
Click Choose File and select the CSV from your system.
Click Upload.
To verify the uploaded data:
Pick any order data from the uploaded CSV.
Navigate to: Hamburger Menu > Find Orders Page.
Search the order and go to the Order View page.
Verify the updated data.
Refer to the table for CSV field details:
| CSV Fields | Descriptions | Required Fields |
|---|---|---|
order-id | HotWax Commerce Order Identification value | Optional |
shopify-order-name | Shopify Order Identification value | Mandatory |
product-id | HotWax Commerce Product Identification value | Optional |
upca | Universal Product Identification value | Mandatory |
new-product-id | HotWax Commerce Order Identification value of the new product | Optional |
new-upca | Universal Product Identification value of the new product | Mandatory |
site | Brand Prefix (Mandatory if multiple brands are available) | Optional |
Edge scenario:
If a product is deleted on Shopify and synced to Hotwax Commerce, you need to change the product ID in Hotwax Commerce to another product ID to fulfill orders for that product. To make changes follow these steps:
Navigate to Hamburger Menu > MDM > EXIM > Imports > Order management > Replace Order Item Product.
Download the sample template CSV and add the following columns:
shopify-order-name
product-id
new-upca
site
Upload the CSV file to Hotwax Commerce.
To find the product ID of the deleted product:
Navigate to Hamburger Menu > Order Management > Sales.
Search for the sales order.
Find the order item.
Click the deleted product to open the Product View page.
Copy the product ID from the header.
Add the product ID in the CSV file.
Last updated