Below is the basic Product Import Template which can be used to import data into Vision Warehousing.
...
Sections on this page :
| Table of Contents |
|---|
Other pages in this section :
| Child pages (Children Display) |
|---|
What are Products
Also known as SKU’s these are the top level information which is used when we receipt each batch of stock into the warehouse. The product contains the default information which speeds up the receipt process for items being receipted.
What is the structure
Every customer has many PRODUCT records
Each product has many STOCK records (each represents a receipt into the warehouse)
Each stock record is located in one or many LOCATIONS within the warehouse
Customer Product Structure
A customer is based in a warehouse which is located on a site.
That warehouse has many locations and those are filled with stock which are of a specific product belonging to a customer
Main Import
The structure and field definitions can be found within the PDF located on the following page
WMS - Data Imports - Vision Implementation - Confluence (atlassian.net)
Product Charging
We generally derive charges for products from a logical entry after the import takes place, so we calculate the charges based on the charges for the customer and the logic to apply those to the products.
...
...
Shows all the fields with some basic sample data and some explanations of what the fields are used for
...
FKProduct Group
...
A list of predefined product groups which the system already contains, should you want to expand this list then let us know.
...
FKProduct Type
...
System Product type table, this is generally used for all products, additions to this will have to be requested
...
FK UOM
...
The Unit of Measure reference table, we have to know how you will measure the product, this is a basic list which can be expanded but should cover cases / liquids
...
Import Template
...
This is where you place your data, we will then load this data into our import tables and then we begin writing scripts to fill the missing fields, and to also derive other fields that are needed for the product import.
| View file | ||
|---|---|---|
|
| Warning |
|---|
Product ChargingWe generally derive the product charging from your product data, we build a script to apply the charging per each product from the customers default |
...
charging structure, therefore it is essential that the charging structure can be linked to the product by means of one of the product fields. e.g. Product Type WINE is always the charge groups "general" |
Basic Product Import Example
Below is the column layout which can be used to import data into Vision Warehousing.
Where you have a system if you can map your output to this import format or where you need to create this manually then simply create a blank spreadsheet with the column titles as below.
| Info |
|---|
There are other fields available, if you think there is something missing please speak to the Implementations team. |
The fields below can be selected and then pasted into an excel spreadsheet, this provides the column heading for the product import table.
FKCustomer | FKProductGroup | FKVATCode | FKCommodityCode | FKCountryWhenceConsigned | FKCountryOfOrigin | FKTaxCode | FKProductType | ProductCode | ProductDescription | PackageDescription | AlternativeCode | AlternativeDescription | KilogramsPerUnit | SinglesPerUnit | SingleSize | UnitsPerPallet | UnitsPerLayer | Height | ContainerQuantity | NetWeightKG | GrossWeightKG | MinStockLevel | MinPurchaseOrderQuantity | MinSalesOrderQuantity | TraderUnitCode | SubUnitCode | StrengthABV | LitresLiquidPerUnit | LitresAlcoholPerUnit | CigarettesPerUnit | CigarettesSellingPricePerUnit | ProductLife | ShelfLifeDays | ProductCostPerUnit | ProductCostCurrency | FKBrand | Vintage | SSCCMandatory | TransportAdjustment | TransportAdjustmentSign | DegreePlato | FKTaxCodeAdditional | DoNotApplyTransportDiscount | DespatchesNeedSSCC | FKUOM | CubicMetres |