Purpose of Commodity Mapping
Commodity mapping can be used to associate an item by their assigned SKU or product ID with several different values, such as weight for shopping carts that do not export the weight. (Walmart, PayPal, Squarespace) Using these settings, the program will match the SKU or product ID to the weight and/or other values you have entered into commodities.Commodity mapping can also be used to input an HTS#/B#, which is usually required on a commercial invoice. Since many shopping carts do not include an option to input an HTS#/B# you can associate an SKU or product ID with an HTS#/B#. So whenever an order is pulled in, the program will match the SKU/Product ID to the HTS#/B# you entered and input the information into the commercial invoice. You can either upload commodities from a CSV file or add in your commodities manually.
Click the Settings tab.
Under “Admin Settings” select “Commodities”.
Uploading Commodities from a CSV file
When clicking the Commodities Setting, you will see a list of the commodities if any have been previously added. To import commodities from a CSV file click the button “Upload Commodities”.
Select “Choose File”.
Select the CSV file saved to your computer with the commodity list.
Click "Upload" after selecting your file.
Match each column from your CSV to the available options in the drop-down menu.
Product ID: Required IF a SKU is not entered. XPS will use the product ID from the integration order data to match the item to the override information in commodities.
SKU: Required IF a Product ID is not entered. XPS will use the SKU from the integration order data to match the item to the override information in commodities.
Pick Location: (Optional) If you enter a “Pick Location” it will be displayed under the “Location” column of the packing slip.
Country of Origin: This will populate in the section for “Country of Origin” in commodities when applicable.
HTS#/B#: This will populate in the section for “HTS#/B#” in commodities when applicable.
Product Name: (Optional) This will override the Product Name from the integration order data if using in combination with the product ID or SKU.
Weight (lbs): This will override* the Product weight from the integration order data if using in combination with the product ID or SKU. (*Or add in the case a weight was not sent.)
Price: This will override the Price from the integration order data if using in combination with the product ID or SKU.
Integration ID: (Optional) Only use the integration ID if you only want the commodity override to only apply to orders from a specific integration, and not all integrations.
*If mapping the "Country of Origin" column, the countries must be saved in the CSV file as the 2 letter abbreviation, i.e. US for the United States. .
**If mapping the “Integration ID” column, you must use the integration number and not the name. To locate the integration ID, you'll need to go into that specific integration, where you will be able to see the number at the end of the URL. For example, in the picture below the integration ID is 79055.
Please note, if you have your own FedEx Account added, and have the option to “Enable Dangerous Goods” checked, you will have the option to enter the following additional hazardous commodity data fields:
Hazardous Accessibility
Hazardous Material Type
Hazardous Radioactivity Detail
Hazardous Cargo Aircraft Only
Hazardous Container Type
Hazardous Commodity ID
Hazardous Commodity Packing Group
Hazardous Commodity Packing Instructions
Hazardous Commodity Proper Shipping Name
Hazardous Commodity Hazard Class
Hazardous Commodity Amount
Hazardous Commodity Unit of Measure
If the file you imported has a header row, click the box “Skip first row” so the headers don’t import as a commodity.
When all columns have been mapped, click “Confirm Import” and your list of commodities will be imported.
How to Manually Enter in a Commodity
Select the "+Add Commodity" option to manually enter in a commodity.
A new box will appear. Select the integration you wish to make a commodity mapping for, enter the Product or SKU number, and select country of origin. Enter an HTS#/B# and click "Save Changes".
Note: When entering less than a whole pound amount for weight you will need to use a leading 0, i.e "0.75".
Your saved information will appear on the page.
How to Edit a Commodity
To modify a commodity, select the edit icon with the pencil on the left.
Here you can update the commodity information. When done click "Save Changes".
To delete a commodity select the trash icon to the left of the commodity listing.
A confirmation will pop up, select "OK" to confirm.
When you pull in the order, the program will automatically input the weight into the package details. If it is an international shipment it will also add the HTS#/B# to the commercial invoice.