Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.



Info
You will be uploading your product data file via the Product Manager. For this, you can use the Onetrail template file or your own Product data file in Excel or CSV format.
Please find below the mandatory and optional fields you can provide.


Column in documentMandatory / OptionalColumn headerRequired dataExample notationAdditional information
AMandatorySKUStock Keeping Unit (SKU) to identify a product. Selling-parties can use SKU numbers in their ERP-system to identify products. This is most often the unique number your customers are using on their purchase orders. The SKU you provide must be unique for you as a Seller. Duplicate SKU records will be ignored or lead to import failure.
Terminology and how to use them 
BMandatoryMFPNManufacturer Part Number. The original part number provided by the manufacturer of a product. The part number you provide should be the original Manufacturer Part Number without any changes or additions. The Manufacturer Part Number you provide must be unique and should have at least 4 positions.
Terminology and how to use them 
CMandatoryShort DescriptionShort Description of the product, max. 35 characters.

DMandatoryLong DescriptionLong Description of the product, max. 255 characters.

EMandatoryBrandBrand name assigned to the product by the Manufacturer of the product
Overview of used brands 
FMandatoryClassificationProduct group name or a classification code
Overview of all UNSPSC codes
GMandatoryVATVAT = Tax Level of the Product High, Low, Null or the percentage in numeric values.
HOptionalProduct EAN (GTIN)EAN Product Number (GTIN) 8, 12, 13 or 14 numeric
What is GTIN?
IOptionalSerial KeepingProduct Serial Numbers will be Scanned Yes/NoYes/No
JOptionalRecommended sales priceRecommended price i.e. Gross Price. The decimal separator is detected automatically.

KOptionalURLSecure URL to Product and/or Picture on Website (HTTPS)

LMandatoryBuyer (GLN)

Global Location Number (GLN) of the buyer. Will be provided by Onetrail.


What is a Global Location Number (GLN)?
MMandatoryCurrencyCurrency in ISO-4217 Code.EUR / USD / GBP etc.
NMandatoryPriceNet Purchase Price, excl. VAT. The decimal separator is detected automatically.

OMandatoryStockStock position. Real stock or Boolean numeric values are allowed.

152 as real value

Boolean:

1(=stock),

0(=no stock)


POptionalOn orderNumber of Units on Order at Supplier/Factory

QOptionalDate stockExpected Availability Date Ordered Units at Supplier/factory. The date format is recognized automatically.

yyyyMMdd

yyMMdd

dd/MM/yyyy

dd-MM-yyyy

dd.MM.yyyy

dd MM yyyy…


ROptionalMOQMinimum Order Quantity

SOptionalUOMUnit Of MeasurementPiece, Blister
TOptionalUOM qtyUnit Of Measurement Quantity, Number of Units in UOM

UOptionalLengthLength in mm

VOptionalWidthWidth in mm

WOptionalHeightHeight in mm

XOptionalWeightWeight in grams

YOptionalSTIBAT NLCountry specific (Dutch) special taksDecimal separator is detected automatically
ZOptionalBUMA STEMRA NLCountry specific (Dutch) special taksDecimal separator is detected automatically
AAOptionalNVPM NLCountry specific (Dutch) special taksDecimal separator is detected automatically
ABOptionalPCE NLCountry specific (Dutch) special taksDecimal separator is detected automatically
ACOptionalBEBAT BECountry specific (Belgian) special taksDecimal separator is detected automatically
ADOptionalAUVIBEL BECountry specific (Belgian) special taksDecimal separator is detected automatically
AEOptionalRECUPEL BECountry specific (Belgian) special taksDecimal separator is detected automatically
AFOptionalREPROBEL BECountry specific (Belgian) special taksDecimal separator is detected automatically
AGOptionalPromotional Price
Decimal separator is detected automatically
AHOptionalPromotional Price Date From

The date format is recognized automatically.

yyyyMMdd

yyMMdd

dd/MM/yyyy

dd-MM-yyyy

dd.MM.yyyy

dd MM yyyy…


AIOptionalPromotional Price Date To

The date format is recognized automatically.

yyyyMMdd

yyMMdd

dd/MM/yyyy

dd-MM-yyyy

dd.MM.yyyy

dd MM yyyy…


AJOptionalNew Price
Decimal separator is detected automatically
AKOptionalNew Price Date From

The date format is recognized automatically.

yyyyMMdd

yyMMdd

dd/MM/yyyy

dd-MM-yyyy

dd.MM.yyyy

dd MM yyyy…