Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 29 Next »

Data Imports - Where to start

You need to know 2 things before you start to look at this section

  1. Which Imports are included with your implementation, most customers have the basic import which include essential information needed to operate the system, see below.

  2. Which style of import are you using, are you supplying the complete information where we only import or are you providing less information where we have to use some logic to fill the remainder of the fields. See the guide opposite.

What are we importing for you

This will be on your sales contract and follows the table below

Import Name

Basic

Enhanced

Complete

Customers

Producers

Products

Stock Import from Vision Warehouse

Suppliers

X

Stock Import from VW + Customer Rotation Values

X

Customer Contacts

X

Product Price Lists

X

X

Customer Price Lists

X

X

Suppliers

X

X

Commerce Optional Imports

These are not normally performed but may be required based on the customers requirements.

Import Name

Stock from External Source

Shippers

Historical Sales Orders

Style of Imports

There are three styles of import, unless a customer tells us they can provide a complete data import not requiring our input then we usually use the logic style, this will be confirmed on your sales contract

Build Import

 

This is the most expensive option as you will provide us with the data which we then have to get into the import templates for you.

If we are involved in obtaining data from your system then we would have to charge an additional cost for this level of import work

This also usually involves two imports of your data as we have no idea whether we will get it right first time. In general this method of importing will take somewhere between 20-40 working days to complete.

This also included building the logic imports and then importing into the system.

Logic Import

This is a half way solution, where you provide us the import templates with as much filled as possible and we will then use logic to complete the rest.

We will then build the import routine, adding in required fields, and mandatory data that the customer could not supply.

This takes us slightly longer to build the import, once done you will have the ability to update the source spreadsheets before we import the data to the live system.

Generally this building of logic will take upto 15 working days to complete.

Direct Import

This is the cheapest option and involved you providing all the data within the import spreadsheets and it is 100% ready to import.

There can be no modifications, changes or alterations the customer has to correct the import file to make it correct.

If you do not have all the data or you feel that we need to perhaps make some changes then a Logic Import is better.

Commerce Data Imports

Each of the links below show the information for each import for Vision Commerce, before starting check your contract to see which imports will apply for your implementation.

If you are preparing the files for import it is important that we receive the files in the order shown below with 10 needed before 20 etc.

Seq

Import Name

Link to Page

10

Suppliers

10. Suppliers

20

Producers

20. Producers

30

Products

30. Products

40

Customers

40. Customers

41

Customer Contacts

41. Customer Contacts

42

Customer Delivery Addresses

42. Customer Delivery Points

50

Product Price Lists

50. Product Price Lists

51

Customer Price Lists

51. Customer Price Lists

60

Shippers

*due to low usage of this import there is no published documentation

70

Stock Import from Vision Warehousing

This is an internal document

71

Stock Import from Vision Warehousing
with client provided values

You will be provided with a document to update the prices into, this will be excel format

72

Stock Import from another system

Supplied on demand, please request.

99

Historical Sales Orders

As this is different for every customer we will prepare something specific for the customer

  • No labels