Knowledgebase
Partial File Upload
Edited by Ash on 09 August 2017 06:49
How to update MinSellingPrice using File Uploader?
When you use ChannelMAX repricer sometimes you may want to change the MinSellingPrice (aka Cost/Min or bottom price) for some of the SKUs present in ChannelMAX 'Repricing' dashboard. It may be for various reasons like you would like to clear the stock quickly or to become more competitive in market. You may refer the following steps just to modify your MinSellingPrice without making any other changes to the values present in 'Selling-->Inventory-->File Uploader(Beta)' dashboard for specific SKUs.
To do this partial update, you may create a tab delimited text file containing the following 3 columns and upload this file via 'File Uploader(Beta)'.
a) SKU
b) Selling Venue
c) MinSellingPrice
Please remember that in a partial update two columns i.e, SKU and SellingVenue are mandatory fields.
SKU coulmn in the file should contain the SKUs which required to be changed, set desired Selling Venue such as AmazonUS, AmazonUK, AmazonFR etc.. then, enter the new MinSellingPrice for the desired SKUs.
When the upload is complete, the changes may be verified in "Repricing" screen.
You may refer this image below to better understand the file structure... Make sure that the inventory file is created in Excel Spreadsheet and then saved as a tab delimited text file before uploading to ChannelMAX.


How to change Repricing Model ID using File Uploader?
Many times you may want ChannelMAX to use different repricing models for certain SKUs present in our 'Repricing' screen. When you would like to change the repicing models for multiple SKUs, it is time-consuming to do them one by one. Hence, ChannelMAX has made it easy to accomplish this requirement by uploading a file containing the desired change. This file should contain the following columns
a. SKU
b. SellingVenue
c. RepricingModelID
'SKU' column should have the SKUs which need to be modified, 'SellingVenue' column should have an appropriate value such as 'AmazonUS' or 'AmazonUK' and 'RepricingModelID' column should have the repricing model ID, which is present under 'Settings--> Repricing Model' page.
Please keep in mind column 'RepricingModelID' should contain the repricing model ID and NOT the name of the repricing model. Please refer this image below.

Partial upload for other changes
* Apart from the above, you may also use ChannelMAX 'File Uploader' icon to update the changes related to MaxSellingPrice/Quantity/Purchase Price/MAP/FolderID etc.
* Each File upload MUST contain two mandatory columns i.e, SKU and SellingVenue. Another column could be the one which requires change like MaxSellingPrice or Quantity or FolderID with appropriate values populated against the SKUs.
* Further, as per the instruction above for changing repricing model ID or MinSellingPrice, the inventory file need to be prepared in excel spreadsheet and then save in tab delimited text file format to upload to ChannelMAX.
(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments: