Orders: Sheet Downloads

Before you begin

This section describes the XLSX stucture for importing order downloads.

Follow these guidelines to properly structure your order file. To follow along, feel free to download an example file.

Important
  • This sheet is required for Orders import.
  • All columns must be present in the sequence specified below.
  • Do not change/translate the names of the columns.
  • Allowed names for this sheet: Downloads

Spreadsheet structure

Here is a list of every column in the sheet Downloads.

To follow along, feel free to download an example file.

Column Letter Column Name Extra Info Allowed Values Required
A Order Download ID If you have an existing order download in your store with this Order Download ID, it will be overwritten. If left empty, the order download will be imported as a new order download. Integer number
Minimum: -2147483647
Maximum: 2147483647
(Conditional)*
B Order ID A valid Order ID. See Orders sheet, column A for allowed values.

Integer number
Minimum: -2147483647
Maximum: 2147483647
Yes
C Order Product ID A valid Order Product ID. See Products sheet, column A for allowed values.

Integer number
Minimum: -2147483647
Maximum: 2147483647
Yes
D Name A valid Download Name. Go to OpenCart Admin > Catalog > Downloads > Edit to see the Name of the download. Yes
E Filename A valid Download Filename. Go to OpenCart Admin > Catalog > Downloads > Edit to see the Filename of the download. Yes
F Mask A valid Download Mask. Go to OpenCart Admin > Catalog > Downloads > Edit to see the Mask of the download. Yes
G Remaining Integer number
Minimum: 0
Maximum: 2147483647
Yes
Note* (Conditional) fields accept empty values for the purposes of an ExcelPort import. There are cases when you might need a value for this field. More information in column Extra Info.