Create Super-CSV Files

Super-CSV files are different from .CSV files because they allow more complicated product data to be uploaded. Super-CSV files allow your product to have more than one result for a field.  For example, multiple descriptions, components, or vendors.

To format product data using Tradeflow's Display Upload Format for a Super-CSV file:

1    Open the product data spreadsheet you want to upload to the PMC.

Figure 1: Sample Product Spreadsheet

2    Delete any spreadsheet titles (for example, Test Company). Click on column A and insert a new column.

3    Type XProduct in cell A1.

Figure 2: Type XProduct in cell A1

4    Type the section definition AA in cell A2. This defines the beginning of the field definitions. All other cells in this row should be blank.

      Then type the section codes of the data that will appear in the product file.  

1. • For each new section code, create a new row. In this example, A in cell A3, B in cell A4, C in cell A5, and D in cell A6.

   • Not all section codes are required, but the order must be maintained (i.e. A, C, N not N, A, C).

      End the field definitions section by typing the section definition AZ after the last section code. See Display Upload Format for Super-CSV Files for section codes.

      AA/AZ define the boundaries of the field definitions.

5    For each section code row, fill in the Field IDs you want to add/modify/delete. The Display Upload Format has the Field IDs for each section code.

Figure 3: Section Codes and Field IDs