Product: TrueCommerce Home (for Vendor)
Before uploading an Inventory Masterfile to the TrueCommerce Home portal, you must have that file saved in the comma-separated value (.CSV) format. The CSV file is to be loaded as the Inventory file to the TrueCommerce Home Retailer Portal. There are two types of Masterfile: Standard and Advanced.
In this article, you will learn how to create an EDI 846 Inventory Masterfile from scratch, ensuring a smooth and accurate upload process.
Creating an EDI 846 Standard Inventory Masterfile
The Masterfile is to be created as an Excel (.xlxs) or Text (.txt) document with four formatted columns.
NOTE: This is not the finalized file that will be loaded as the daily inventory to the Retailer Portal inventory tab. Changes and updates will be made to the Masterfile and once the inventory file is ready for upload, the Masterfile will be saved as a .CSV file.
Mandatory (*) and Optional Columns
Column A = QTY on Hand * | Column B = UPC Code * | Column C = Model Number (Style) * | Column D = Availability Date * |
This value represents the quantity that is available for the Retailer to sell to customers. Column A must be in a text format.
| The UPC value is typically 12-13 digits.
If using an .xlxs Masterfile, Column B must be in a text format.
UPC codes must be unique. If any duplicates exist, the file will fail to load. | Includes the Model number or Style number.
Column C must be in a text format.
| The Availability Date represents the date that the product is available.
Standard format for availability date is yyyymmdd. |
Column E = Qty on Order | Column F = Qty on Order Arrival Date | Column G = Unit Price | Column H = SKU |
The quantity on order. | Standard format for date is yyyymmdd. | Items Unit Price. | Items SKU. |
Qty/date logic
If QTY=0 and the product has been discontinued, enter the date 20491231.
NOTE: A discontinued item must be present at least once on an inventory upload before removing.
If QTY=0 and the the product is back ordered, enter the future date when the product will be available.
If QTY is greater than 0, enter the current date.
Example
The expected standard formatting for each column should appear as follows:
NOTE: Once the Masterfile has been officially created, it is highly recommended to pass this file to an TrueCommerce Home representative for review and approval.
Creating an EDI 846 Advanced Inventory Masterfile
The Masterfile is to be created as an .xlxs or .txt document with twelve formatted columns.
NOTE: This is not the file that will be loaded to Retailer Portal. Changes and updates will be made to the Masterfile and once the inventory file is ready for upload, the Masterfile will be saved as a .CSV file. The CSV file is to be loaded as the Inventory file to the Retailer Portal.
Mandatory (*) and Optional Columns
Column A = QTY on Hand *
| Column B = UPC Code * | Column C = Model Number (Style) * | Column D = Availability Date * | Column E = Qty On Order |
This value represents the quantity that is available for the Retailer to sell to customers.
Column A must be in a text format.
| The UPC value is typically 12-13 digits. If using an .xlxs Masterfile, Column B must be in a text format.
NOTE: UPC codes must be unique. If any duplicates exist under the same Warehouse Code in Column I, the file will fail to load. | Includes the Model number or Style number.
Column C must be in a text format.
| The Availability Date represents the date that the product is available.
Standard format for availability date is yyyymmdd. | The quantity on order.
|
Column F = Qty On Order Arrival Date | Column G = Unit Price | Column H = SKU | Column I = Warehouse Code * | Column J = Warehouse Name |
Standard format for date is yyyymmdd.
| Items Unit Price.
| Items SKU.
| The warehouse code that represents the warehouse location. | The Availability date represents the date that the product is available.
Standard format for availability date is yyyymmdd. |
Column K = Street | Column L = Street2 | Column M = City | Column N = State | Column O = Zip |
Warehouse Street. | Warehouse Street. | Warehouse City. | Warehouse State. | Warehouse Zip.
|
Column P = Country | Column Q = QTY On Hand | Column R = Availability Date | Column S = Item Brand Name | Column T = Item Description |
Warehouse Country. | This value represents the quantity that is available for the Retailer to sell to customers in this warehouse.
Column Q must be in a text format. | The Availability date represents the date that the product is available in this warehouse.
Standard format for availability date is yyyymmdd. | Brand Name. | Item Description. |
Qty/date logic
If QTY=0 and the product has been discontinued, enter the date 20491231.
If QTY=0 and the product is back ordered, enter the future date when the product will be available.
If QTY is greater than 0, please enter the current date.
Example
The expected advanced formatting for each Column should appear as follows:
NOTE: Once the Masterfile has been officially created, it is highly recommended to pass this file to anTrueCommerce Home representative for review and approval.
In summary
Creating an EDI 846 Inventory Masterfile for the TrueCommerce Home portal is a straightforward process when you follow the correct steps. By ensuring your file is saved in .CSV format and selecting the appropriate Masterfile type (Standard or Advanced), you can streamline your inventory management and avoid upload issues.
Please note that not all retailers accept the EDI 846-inventory feed and all the available columns. Every Retailer Customer has different requirements for the 846-inventory feed. Always check with Truecommerce to obtain the requirements for a retailer you wish to send inventory to before uploading.
rev: 09/22/25