Talk:RepricerSetup

From ChannelMAX

Jump to: navigation, search

Contents

How to quick edit Min/Max prices, Purchase Cost, Actual shipping Cost and MAP in Repricer?

We can edit min and max prices in ChannelMAX Repricer as per the following 2 ways

A
Open Google Chrome or FireFox
Login to selling.channelmax.net
Click on "Repricing"
1. Search by SKU or ASIN
2. Mouse over Min or Max column and click on the pencil icon
3. Enter new values in desired fields Retail/Max or Cost/Min or Purchase Cost or Actual Shipping Cost or MAP in Q500 panel
4. Click on Save.

File:Q500 Panel.png

B
Enter appropriate Min or Max column value as shown below in Repricing screen and finally click on save button (floppy disk) icon displayed on top right of the screen.

File:Min-Max-Edit-Repricing.png

ChannelMAX Profit Calculator

Here is how the profit calculator could be used by clicking on calculator image under 'Min' column in "Repricing" screen.

Input Product Unit Cost and Markup in either % or $ and system would auto add Estimated FBA fee(if SKU is FBA) and Amzn Commission and display Min Selling Price and Max Selling Price of the SKU at the bottom of the window.

P.S: In this panel Product Unit Cost means, procurement cost of the item and ' Markup' meaning the extra profit you want to add to the cost.

File:Selling-Profit-Calculator.png

How to edit quantity for an SKU?

Below is how to update quantity in ChannelMax Repricer.

Open Google Chrome or FireFox
Login to selling.channelmax.net
Click on Repricing
1. Search by SKU or ASIN
2. Click on green color 'GO'
3. Click on pencil icon below column 'Qty'
4. Enter numerical value in quantity field
5. Click on the green color floppy disk icon to save.

File:Edit-Quantity.png

Alternate way using File Upload

You may create a file in tab-delimited text format containing following columns and upload this file using 'Inventory-->File Uploader' screen to bulk change quantity in ChannelMAX.

1. SKU
2. SellingVenue
3. Quantity

How to Assign an SKU to a Repricing Model created?

Below are the steps to assign an SKU to a Repricing Model created.

a. Open Google Chrome or FireFox
b. Login to selling.channelmax.net
c. Click on Repricing
d. Search by SKU or ASIN
e. Click on R.Model
f. Choose new R Model from the drop-down list
g. Click on "Save"

File: Assign-SKU.jpg

Alternate option for bulk updates using 'File Uploader'
You may create a file in tab-delimited text format containing following columns and upload the file using 'Inventory-->File Uploader' screen to bulk assign SKUs another Repricing Model.
SKU
SellingVenue
RepricingModelID
P.S: RepricingModelID column should have the R Model ID, which is displayed in 'Settings-->Repricing-->Repricing Model' page.

Purchase Price in ChannelMAX Repricing

You may store your actual item (SKU) purchase price (or the procurement price from vendor) in ChannelMAX. This value is not used for any calculation while repricing or managing inventory. At the time of order download, the corresponding purchase price is recorded into the the sale transaction along with shipping, commission and listing fee (if any), this information could be then used while calculating net profit on the sale. The currency of the Purchase Price would be recorded in the currency of your default Amazon locale in ChannelMAX. For Amazon US, it would be stored in dollars, and so on.

You may update 'Purchase Price' directly on the 'Details' tab of the SKU as shown in the below screenshot or you may upload 'PurchasePrice' via Selling-->Inventory-->File Uploader.

File:Selling-Purchase-Price.png

 

How to assign an SKU to a non-default Selling Venue?

When you manually create an SKU, by default SKU is added to default Selling Venue. If you wish to add an SKU to a non-default Selling Venue (lateral venues added for Repricing), you may create an SKU on Repricing screen and then follow below steps to assign that specific SKU to the desired Selling Venue.
1. Search for desired SKU or ASIN.
2. Click on 'Multi-Chanel'on the top right of your Repricing screen, just below Selling Venue.
3. Now, near SKU name, checkmark the white box.
4. Click on the currency symbol near the Selling Venue for which the SKU needs to be assigned.
5. Now, within Q500 panel, enter ASIN, Retail/Max, Cost/Min, etc.. and click on "Save" button.

File: Selling-edit-multi-channel.png

How do I manually create an SKU on Repricer screen?

Open Google Chrome or FireFox
Login to selling.channelmax.net
Click on "Repricing" menu
Click on "Actions--->Add Item"
In the new panel opened, input the following information and click on "Add SKUs" tab.
SKU*
Title*
Qty*
Retail/Max*
ASIN (Amazon ASIN)
Cost/Min (aka Bottom Price aka floor)
Please note the fields marked with stars ' * ' are mandatory to add new SKU. For repricing, we need the additional fields 'ASIN' and 'Cost/Min' populated with appropriate values.

File: Selling-add-item.png

How to delete an SKU from Repricer?

  • Open Google Chrome or FireFox
  • Log in to selling.channelmax.net
  • Click on Repricing
Manual Delete of an SKU
1. Checkmark the SKU near SKU name
2. Click on "Actions-->Move To Folder"
3. Click on "Trash" folder and then "Update"
4. Click on "Yes, Move" on confirmation panel

File: Delete-SKU-manual.jpg

Alternate option to delete an SKU is using Actions-->Mass Update.
1. Tick mark white box near SKU name
2. Click on "Actions-->Mass Update"
3. Tick mark near FolderID and then choose Trash Folder ID from dropdown list
4. Click on "Update" button.
5. On the Confirmation panel click on "Yes, update!"

Note: Once deleted, the SKU name will have strike thru.

File: Mass_update-folder.jpg

How to un-delete an SKU in ChannelMAX?

This link explains how to move an SKU from 'Trash' folder to default 'SKUs' folder for repricing.
Open Google Chrome or FireFox
Login to selling.channelmax.net
Click on 'Repricing' menu
1. Click on 'Trash' from the drop down option Counts#
2. Tick mark SKU that has strike thru,
3. Click on "Actions-->Move To Folder"
4. Click on "Default-->Update"
P.S: Once undeleted, the SKU will NOT have strike thru.

File: Un-delete-Trash.png

How do I purge the SKUs from Repricer Trash folder?

Please follow the following steps to purge trash folder in ChannelMAX Repricer.
1. Click Actions->Purge Trash[Off]
2. Set 'Purge Trashed SKUs' to "Yes"
3. Click "Empty Trash"
Note: Depending on the number of SKUs you have in the trash folder, it may take around 60 minutes to empty trash.

File:Selling-Purge-Trash.png

Refresh Repricing

Sometimes, the prices displayed on 'Selling-->Repricing' may not have been refreshed with the latest repriced information. You may refresh the prices displayed in ChannelMAX Repricer by navigating to Actions-->Refresh Price View-->Refresh Price View which would allow the Repricer to update the prices as per the latest Repricer Report available under 'Settings-->Repricing-->Run Logs'.

File: Refresh-price-view.jpg

Mass Update

In "Repricing" using 'Actions-->Mass Update' tab, you may bulk change folder ID, repricing model, inventory profile, item condition, Min, Max prices etc..

  • Open Google Chrome or FireFox
  • Login to selling.channelmax.net
  • Click on Repricing
  • Choose desired set of SKUs by selecting the checkbox near SKU name.
  • Click on 'Actions-->Mass Update' tab and change any of the options as desired.
a) To change Repricing model, please check mark the box near 'Repricing Model' and then choose new Repricing model.
b) To change Folder, check the box near 'Folder' and then choose a new folder from the drop-down list.
c) To change Item Condition of SKUs, check the box near 'Condition' and choose a new condition from the drop-down list.
d) To change 'Lead Time To Ship' information, please check the box next to the name and choose a new value from the drop-down list.
e) To change Inventory Profile, check the box next to it and choose a new Inventory Profile from the drop-down list.
f) To change Retail/Max, Cost/Min, MAP, Actual Shipping Cost, please check mark the box as needed and enter the values to be changed in respective text boxes.

Please note, if you want to apply the changes to all SKUs displayed on Repricer screen, you may tick white color box below "All" or if you wish to apply to only a few SKUs on the page, please check the white color box above + sign(near SKU value) before navigating to 'Actions-->Mass Update'.

File:Mass-update-functions.jpg

How to add a new Selling Venue to your ChannelMAX account?

Please refer to the following steps to add a new selling channel for repricing.

1) Authentication

To add new Amazon Selling Venue in ChannelMAX first you need to obtain Amazon Authentication token (aka Auth Token). How to obtain Auth token is documented in another link which can be invoked by clicking here.

Once Auth token is obtained, please login to ChannelMAX at selling.channelmax.net
Once you login, navigate to Settings --> Account --> Selling Venues.
Click on the appropriate/desired Amazon lcoale such as Amazon US, Amazon Canada etc.
Once clicked on the right hand side of the panel, input the Seller ID and the Amazon Auth token (just obtained) and click on 'Save SellingVenues'.

File:Settting-Acct-SV-NewLocale.png

2) Inventory Import

When your new account is created, we auto download your active listings from Amazon seller central with the current Amazon price set as Max in Repricing. But, when additional selling venue is added, we do not auto download your inventory unless the auto-import option is turned on. You may click on this link to enable import options from Amazon.

3) Floor/Ceiling Setup

For repricing, we need floor price too. Therefore, as soon as the SKUs are downloaded from Amazon, they would not get repriced unless you add an appropriate floor or Cost/Min. Your floor price is controlled based on the Floor Rule#35 under Settings-->Repricing -->Repricing Model-->Floor/Ceiling tab and the ceiling is controlled based on Ceiling Rule#42.

4) How to manually edit Min and Max prices under Repricing?
a) Enter appropriate Min and Max prices under respective columns.
b) Click on Save icon (floppy disk icon) displayed on top right of the screen.

File:Min-Max-Edit-Repricing.png

5) How to create inventory file?

Please note that ChannelMAX accepts only Tab-delimited text file(.txt format). We would need your inventory file prepared with the following columns

SKU
SellingVenue (this column should have value AmazonUS or AmazonUK or AmazonDE or EbayUS etc...)
ASIN
MaxSellingPrice
MinSellingPrice
When the file is created with the above columns in a spreadsheet, please save it in tab-delimited text(.txt) format.
Here is how the file structure would look like

File: Excel_file_layout.png

6) How to upload inventory file to ChannelMAX?

When you have the file ready in tab-delimited text format, please refer to the following steps to upload this file to ChannelMAX. Once the file is uploaded, inventory can be viewed using Repricing menu within your ChannelMAX account.

  • Open Google Chrome or FireFox
  • Login to selling.channelmax.net
1. Click on "Inventory-->File Uploader"
2. Click on "Analyze New file"
3. Choose the file from your Computer
4. Click on "Upload File Content to ChannelMAX".

File:Selling-fileuploader-new.png

7) By default, Repricer would work based on the Default Repricing model setup in your account. If you wish to Reprice the SKUs assigned to this new selling venue differently from the default setup, you may create a new repricing model under 'Settings-->Inventory-->Repricing Model' screen and assign the SKUs to this new model created. Click here to read default repricing strategy.

8) Repricer Schedule

Finally, your Repricer schedule needs to be configured under Settings-->Repricing-->Schedules page for the Selling Venue newly connected under "Settings-->Account -->Selling Venues" by clicking on 'Create New Schedule' button.

File:Settings-Repricing-Schedules.png

9) How to check if the Repricer is running normally?

Once Repricer is made live by unchecking reprice Rule#44a under 'Settings-->Repricing-->Repricing Model', you may view the entries under 'Settings-->Repricing-->Feed Status' with records '_DONE_' under Status column for the number of SKUs repriced.

File:Job-Process-Log.png

10) How to download Repricer R Report to Excel?
  • Open Google Chrome or FireFox (not IE)
  • Login to selling.channelmax.net
  • Click on 'Settings-->Repricing'
  • Click on 'Run Logs'
  • Click on the 'R' link, its the 4th column from right on the grid

File:Submitted-Process-Log.jpg

Once clicked on 'R' link, it will download a file with extension .7z, save it to a location on your computer.
The file name will be something like nnnn-loginname-RepriceReport-Pnnnn-Snnnnnnn.7z
a. Download and install 7-zip from www.7-zip.org (download the exe version)
b. On the 7-zip file that you downloaded from ChannelMAX
c. Choose 'Extract Here' or 'Extract To `folder-name`'
d. Once extracted, you can open the resultant text (.txt) file using Excel
e. Since the number of columns is much more than Excel supports, you will get a warning while opening, ignore the warning.
f. Once you install 7-zip, if you right click on the file, you will see the option to extract the file. Please see this screenshot

File:7zip-Extract.png

How do we auto import inventory from Amazon seller central?

You may enable auto-import options as below to download your active nonFBA and FBA listings from Amazon seller central.

  • Open Google Chrome or FireFox
  • Login to selling.channelmax.net
  • Click on 'Settings-->Account-->Selling Venues'
a) Choose desired Selling Venue under 'Selling Venues'
b) Navigate to "Inventory Download" section
c) Enable Option#4e to auto import merchant fulfilled listings.
d) Enable Option#5a to auto import FBA listings and click on 'Save Autofulfill Settings'.

File:Import-Enable.jpg

Please note the following points#

1. Enabling option#4e would allow us to auto-import FBM listings i.e, merchant fulfilled listings with positive qty only.
2. Enabling option#5a would auto-import only active FBA SKUs from Amazon.
3. Another point to be noted is when we auto import the listings, your current price on Amazon will be stored as "Max" in "Selling-->Repricing" with zero "Min" values assigned. Hence, Repricer would not work on these SKUs with missing "Min" values.
4. You may update the "Min" as outlined in this link manually or Upload appropriate min and max values using "Inventory--> File Uploader".

Download/Export Inventory from ChannelMAX

Click here for more links on inventory download
Below are the steps to download your inventory from ChannelMAX.
a. Open Google Chrome
b. Log in to selling.channelmax.net
c. Click on Repricing
d. Navigate 'Actions-->Download Inventory'
e. Choose desired template
f. Finally, click on 'Download'
Note 1: Create a new template by dragging & dropping required columns to the "SELECTED COLUMNS" list from "AVAILABLE COLUMNS" and then click 'Save Template As'.
Note 2: By default file will be saved in your computer Downloads/ folder or as per your browser settings in tab-delimited text format. Next, right click on the .txt file name and open with excel spreadsheet.

File:Export-Inventory.jpg

Repricing History

You may click on the graph image on 'Repricing' page to view Repricing history of a SKU.

In this Repricer history panel, 'Total' column would display your price of the listing during the time-stamp displayed under 'When' column.

Under 'BBox Ind' column, you would see who is holding buybox,
M = MySelf
N = nonFBA competitor
F = FBA competitor
A = Amazon

Alternate option to see Repricing history is by navigating to 'Reports-->Repricing-->History' page.

You may view the following screenshots.

File:Selling-Repricer-History.png File:Selling-Reports-Repricerhistory.png

Custom Repricer View

On your 'Repricing' page, you may customize the display of the columns as per your requirement. By default SKU, ASIN, Product names, Min, Max, Notes, BBox rotation %(R%), Competitor etc.. are displayed. However, if you want to view only selected columns when logged into Repricing page and doesn't want to view default information, please do the following:

  • 1. Click on the horizontal lines image located below "Views" on top right of the screen
  • 2. Next click on the column headers to be removed from display, when you do that selected columns would display as x instead of tick mark
  • 3. Now, click on Views-->Save View
  • 4. Enter a name for the view and proceed.

File:Selling-Repricing-ChangeView.png

How to view Inventory Adj Report?

In ChannelMAX 'Repricing' page, you may click on the master qty(blue color qty) to view "Inv Adj Rpt". This report would provide you the details of how the quantities were adjusted on a specific SKU. You may also view this report by navigating "Reports-->Inventory-->Inv.Adj Report" screen for all SKUs.

Below is how to read this "Inv Adj Rpt" panel:

Site = Selling Venue ID for which the transaction is triggered. If qty is adjusted manually then it would show site number as 700.
Adj.ID = ChannelMAX Internal TransactionID, higher the value, more recent the transaction
Adjusted At = Date-Time when adjustment was made
Actn = This column would display any of the following actions
a) INV-ADJ  : Adjustment recorded when that specific SKU's quantity is adjusted
b) INV-ADJ-C : Applicable for MasterSKU, adjustment recorded when child SKU is adjusted
c) INV-ADJ-S : Applicable for sibling SKU, adjustment recorded when sibling SKU (for same masterSKU) is adjusted
d) INV-ADJ-BUN : adjustment recorded when one of SKUs that is part of the bundle (aka kit) is adjusted
e) SOLD  : Transaction recorded when that specific SKU is sold
f) SOLD-B : recorded when a bundle SKU is sold
g) SOLD-C : Applicable for MasterSKU, sale recorded when child SKU is adjusted
h) SOLD-S : Applicable for sibling SKU, sale recorded when sibling SKU (for same masterSKU) is adjusted
i) SOLD-S-B : Applicable when a sibling bundle SKU is sold(if a bundle SKU is linked with more than one item)
Channel OrderID = Transaction ID if the qty is subtracted due to the selling in Amazon or any other Sellinge) Venues.
Orig = Original sell able quantity
Adj = Quantity value which is added
Net = Net Quantity available for selling
Tr.Price = The price at which selling happened
Ship Cost = Shipping amount of the item
State = The Selling Venue in which the transaction got triggered.
File:Selling-Inv-Adj-Reports.png

How to check 'Cost Adjustment' report?

In ChanelMAX "Repricing", you may check "Cost Adjustment" report to see details of cost adjustments that are performed on a specifc SKU. You may click on C near quantity of the SKU to view "Cost Adj.Rpt" panel. You may also view this report in detail by navigating 'Reports-->Inventory-->Cost.Adj Report' screen. Below is how to read this panel shown in the image that follow...

Adj.ID = ChannelMAX Internal TransactionID, higher the value, more recent the transaction
Adjusted At = Date-Time when adjustment was made
Action = 'Manual' when user changes manually using 'Repricer/Inventory' screen,
'FileUpload', when adjusted via file uploader
Orig = Cost/Min value before the adjustment made
Adj = The difference between the Old Cost/Min price and new Cost/Min
Net = The final value
State = If processed by any process as needed

File:Selling-Repricing-Costadjreport.png

How to view Selling Venue specific statistics?

ChannelMAX allows you to reprice multiple Selling Venues i.e, Amazon locales such as Amazon US/CA/UK/DE/FR/IT/ES/JP, rakuten.com(buy.com), eBay US, Play.com, Sears etc.. Hence to view the information present in CMAX inventory by SellingVenue, we have designed 'Site-Stat' tab which would display Selling Venue specific information.
In ChannelMAX, you may have the same SKUs assigned to multiple Selling Venues and Repricer would consider the repricing rules, Min/Max values in common from the 'Default' Selling Venue or from the site-specific information configured.
For example, you may be having 500 SKUs in ChannelMAX inventory which are assigned to Amazon UK and Amazon US Selling Venues. Out of these 500 SKUs, some may be missing with Retail/Max or Cost/Min values for Amazon US or for Amazon UK. Another set of SKUs may be missing with ASIN in one of the Selling Venues authenticated. In this kind of scenarios, how to find what inventory is assigned with appropriate Min/Max values or ASINs or repricing models is a question that arises. You would find an answer for all these doubts under 'Site-Stat' tab. Below is how to understand the statistics associated with a specific Selling Venue.
  • Login to selling.channelmax.net
  • a) Click on Repricing
  • b) Click on 'Filter-->Stat Filter++'
  • c) Now click on 'Site-Stats' tab

Here are the details of 'Site-Stat' tab:

  1. withASIN = ID/ASIN assigned
  2. noASIN = No ID/ASIN assigned
  3. withMax = Number of SKUs assigned Retail/Max
  4. noMax = Number of SKUs not assigned Retail/Max
  5. withMin = Number of SKUs assigned Cost/Min
  6. noMin = Number of SKUs not assigned Cost/Min
  7. withMAP = Number of SKUs assigned MAP
  8. noMAP = Number of SKUs not assigned MAP
  9. withASC = Number of SKUs assigned Actual Shipping Cost
  10. noASC = Number of SKUs NOT assigned Actual Shipping Cost
  11. With Rule = SKUs assigned to non-default R models
  12. Default = SKUs assigned to default repricing models
  13. With Lead = With Shipping Lead time
  14. No Lead = Without Shipping Lead time
  15. WithCAT = With marketplace Amazon product category assigned
  16. NoCAT = Without marketplace Amazon product category assigned
  17. With Con = With marketplace item conditions assigned
  18. NoCon = With No condition
  19. With Rel-ASIN = SKUs with Related ASINs assigned
  20. No Rel-ASIN = SKUs without Related ASINs assigned
  21. Listed by CMAX = List of SKUs created by ChannelMAX
  22. Listing Error = List of SKUs could not be created by ChannelMAX for errors

File:Selling-Filter-SiteStats.png

Other Filter options available

Price View Tab

In Repricing page, by navigating "Filter-->Stat Filter++-->Price View", SKUs could be filtered by your active SKUs, inactive SKUs, at floor price or at buybox etc..

(1) Number of active SKUs
(2) Number of closed/inactive SKUs
(3) This displays the number ASINs in error, such as removed by Amazon
(4) Currently at floor
(5) Currently above floor
(6) Currently lowest priced SKUs
(7) Currently not lowest
(8) BuyBox count - It represents for how many SKUs you held BuyBox at the time of repricing.
(9) Not in BuyBox count
(10) Rotate count represents those SKUs for which you don't have BuyBox but you are in the 'BuyBox Rotation'.
(11) Deadbeat count represents those SKUs for which your floor (bottom price) plus shipping is atleast 5% higher than that of BuyBox total price. Deadbeat SKUs will be hard for you sell as you would seldom get BuyBox on these SKUs. You may lower your Cost/Min to become more competitive.
(12) Number SKUs for which price went up in the last repricer
(13) Number SKUs for which price went down in last repricer
(14) Number of SKUs for which prices did not change compared to previous reprice process
(15) This displays the number ASINs where Amazon is selling
(16) This displays the number ASINs where Amazon is not selling
(17) This displays the number ASINs in where Amazon is holding BuyBox
(18) This displays the number of ASINs in where you are the only seller in Amazon
(19) This column displays the number of ASINs with competitors
(20) This column displays the number of ASINs with FBA competitors
(21) This column displays the number of ASINs without FBA competitors
(22) This column displays the number of ASINs at ceiling/max price.
(23) This column displays the number of ASINs above ceiling price
(24) This column represents the number of ASINs below your MAP
(25) This column represents the number of ASINs above MAP
(26) This column represents the number of ASINs with multiple SKUs in repricer
(27) This column represents the number of ASINs with only one SKU in repricer.

Filter-->Defined Value Filter--> Counts

Using 'Filter-->Defined Value Filter--> Counts', you may filter the SKUs as below

SKUs {Trash} {Zero Qty}
BundledSKUs {Master SKUs} {FBA}
Non-FBA {Merchant Prime} {With ASIN}
With FBA SKUs {With Images} {Without Images}
With EAN {Missing Min} {With UPC}
With Attribute {Without Attribute} {With Description}
Below Reorder Level

File:Filter+-Counts.png

Filter-->Defined Value Filter--> Range

Using 'Filter-->Defined Value Filter--> Range', you may filter the SKUs by value range, for example, to filter the SKUs with the Max price between $50 and $150 only.

1) Max
2) Min
3) MAP
4) Act Sh Cost
5) Qty

File:Filter+-Range.png

Filter-->Defined Value Filter-->Additional

Using 'Filter-->Defined Value Filter-->Additional', you may filter the SKUs by

1) Repricing Model
2) Marketplaces
3) With CatalogID
4) Item Condition
5) Amazon Category
6) Folders
7) Inventory Profile

File:Filter+-Additional.png

How to assign an SKU to different R Model for different Selling Venues?

If you are selling an SKU on multiple Selling Venues and want to reprice it based on different Repricing Models on different Selling Venues, then you can set it up under Repricing screen by following below steps:

1. Search for the SKU.
2. Click on the "+" under SKU column.
3. Select "Venues" Tab.
4. Click on the Pencil symbol next to locale for which you want to change Repricing Model.
5. Select appropriate Repricing Model from the dropdown next to "Rep.Model" to which you want to assign this SKU for respective Selling Venue.
6. Click on "Update".
File:Site level R Model.png

Personal tools