With Vision Warehousing (WMS) you can upload products using two different methods, however before you start imports you should consider whether this is worthwhile because with the recent changes to the pre-advice you can now setup a new product faster and quicker by using the CREATE option on the pre-advice lines.
The import form is divided into two separate tabs:
EDI Imports
This is the screen that imports the final product into Vision WMS, the information here comes from:
EDI inbound new files (using Vision EDI)
VCIS new products (using Vision CIS web portal)
Excel Import screen following basic validation
Excel Import
This licensed feature allows you to take a simple excel, CSV file and load it into the system with very basic information in it, anything loaded through this will validate and put the record into the EDI Imports tab for final import and update.
Contents of this page :
Table of Contents | ||||||
---|---|---|---|---|---|---|
|
Overview
EDI : Pending EDI Import
This form shows all products loaded into the system from any of the multiple ways you can load products.
Info |
---|
Customers can send duplicates, if this is identifed then the ‘Already Exists’ will have a tick in the box |
Importing the Products from the Pending Import
Clicking on a Product in the any of the import lists will open up the Product Maintenance screen.
It will auto-complete the new product record with the details that have been provided already, you just need to check verify add any missing details and then submit.
Tip |
---|
See the Create Product wiki page for details of the product maintenance fields and how to use that form. |
Excel Import
You can import into the system using CSV or Excel, it is a very basic import but can save time when importing large volumes of products into the system and there is no need for an EDI XML file to be created.
Products loaded here need to be “Exported” to push them into the EDI:Pending EDI Imports which is where you then perform the actual loading into the system.
This feature requires a license to enable it to be used.
Prepare the File
The file is an import file so either a csv or an excel workbook, it only looks and imports a single page excel workbook.
All fields in the import field list need to be in the table, if a field is to be left blank this should be empty (not containin a 0)Create Template
The system can create you a template extract which is provided in a csv file, if opened in excel afterwards this will provide you with a spreadsheet with all the relevant columns in place, the export is the complete list, you can however trim this down to the essential fields on the basic import below.
Basic Import
Essential fields and the nice to have fields which are regularly imported are shown below, if you want to look at the entire list then expand the section beneath this to see the entire list of import fields.
Field Name | Description / Notes |
---|---|
Site** | |
Customer** | |
Product Code** | |
Brand Name** | |
Description** | |
Alt Lang Desc | |
Year | |
Singles Per Case** | |
Single Size** | |
Product Type Code* | |
Product Group Code* | |
UOM UID* | |
Country of Origin Code* | |
Cases Per Pallet** | |
Cases Per Layer** | |
Net Weight KG** | |
Gross Weight KG** | |
Tax Code* | |
Additional Tax Code* | |
Commodity Code* | |
LOL Per Case* | |
Strength** | |
LOA Per Case* | |
Product Cost Per Case | |
Product Cost Currency** | |
Insurance Cost Per Case | |
Insurance Cost Currency** | |
Freight Cost Per Case | |
Freight Currency** | |
Goods In Charge UID** | |
Storage Charge UID** | |
Charged By UID** |
Expand | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Complete TemplateThis is a list of all the potential import fields for product import.
|
Edit Existing Products
Complete - Upload
Expand | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||||||||||||||||||||||||
Excel ImportThe import format for this tab is simply the same as the fields shown on the top of the form, if you insert those fields in the same order into an excel spreadsheet or a CSV file this will be able to import.
Charge ID’s
|
Loading the file
When the file is prepared you will need to load the file into the system
To load the file into the system, click on the icon on the top right of the tab
this will open up a new window and you need to select the import file from the location you saved it.
If you are using the paste then click on the paste in the icon on the top right
Export the Entries
Once imported succesfully you then need to push the imported data into the “Pending EDI Products”
Select the line
Press the export button for each line
Once in the EDI tab, the products can be loaded into the system