This group contains three menu options, within the interfaces option there are two specific and very different functions so these have been split into seperate sections.
This page contains the following information
| Table of Contents |
|---|
There are seperate pages for the following
| Child pages (Children Display) |
|---|
Interfaces - Import Export - Price Lists
FILE TAB
The Export and Upload functionality is found in the FILE tab of the form, this is designed to allow you to easily update prices on products, product price lists, and customer price lists.
| Note |
|---|
This is ONLY designed to allow you to amend existing prices |
What is the process ?
Export the Price list you wish to modify
You can export
Product Prices
Product Price Lists
Customer Price Lists
Specify the directory where you want the files to be downloaded to.
The system will then export a file which can be edited in excel or a similar application.
Open the price list in excel and update the prices
| Note |
|---|
You should only update the sales prices on the files and reupload, make sure you do not alter the other information on the line especially the first field which is used to load the data back into the system. |
Use Excel
Save the price list in the upload location
Upload and validate the price list
When you have finished editing the files save them and go back to the system but this time use the UPLOAD button
When you upload the data you will be asked to provide a directory for the location of the file, this will then load the data and you MUST validate whichever price lists you loaded.
| Tip |
|---|
If item 4 is succesful then the prices will immediately be updated. |
Validation Issues
Anything which has failed validation will be shown in the VIEW/EDIT rejections page and from here you can double-click on the item, correct the issue and then resubmit it.
Interfaces - API Incoming Monitor
API TAB
You can monitor incoming and update for incoming items using the API, this include items coming from
Your website
Vision Insight
Vision Horizon
| Warning |
|---|
It shows only the items have NOT been able to go directly into the main system. You can choose whether you want this to be fully automated in the API options |
Customer
Incoming new customer or updates to customers will flow through this monitor, any which need to be manually added will be shown on the form, where you can update the fields and then push them into the main Commerce system.
Orders
Incoming new orders are processed through the orders tab on the menu. If you have manual processing or there is an issue with the order it will be in this screen waiting for you to push it onto the main system.
Audit Log
if you wish to look at the details of what has been happening then you should view the audit log which provides a complete breakdown of all the transactions being processed
| Tip |
|---|
The information shown on the tabs is the complete information we have been sent from the external application. All fields are shown nothing is hidden |
What do you have to do
If you want to complete the information you can simply enter the missing information or double-click the entry will provide you with a form for key information which is missing, if there are further details which you have not noticed are missing then these need to be filled in.
| Note |
|---|
When this interface is tested we expect the web provider to consistently provide the correct information in the field so failure for items which are mandatory should not be happening. There are however some fields that the website does not know and those fields may need to be entered at this point. |
How do you configure what happens in this tab
The API Maintenance tabs help you define what happens when items come in through the API menu.