VW Import - Products

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.

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.

The fields below can be selected and then pasted into an excel spreadsheet, this provides the column heading for the product import table.