Talk:Inventorymanagement

From ChannelMAX

Revision as of 10:26, 8 August 2014 by Cmaxwiki (Talk | contribs)
(diff) ← Older revision | Current revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Contents

Inventory Management Across Multiple Sites

To manage inventory ChannelMAX must be able to download orders from that site on your behalf. Suppose you want to manage inventory across eBay and Amazon, then ChannelMAX (behind the scene) first would download the orders from both Amazon and Ebay, adjust the available quantity in ChannelMAX for the impacted SKUs and then net quantity after considering orders from both the channels and any manual change, will be fed back to the venues. For example, suppose

  1. your quantity in ChannelMAX is 10
  2. you manually adjust the quantity to 12
  3. you sell 3 qty of SKU-123 in Amazon, net is now 9
  4. you sell 2 qty of SKU-123 in EBay, net is now 7
  5. now ChannelMAX will feed 7 to both Amazon and EBay
The first step
is to upload your file containing SKU, Selling Venue and Quantity to ChannelMAX. This step is extremely important as once you turn on inventory management using ChannelMAX, the quantity in ChannelMAX will be treated as master and will be fed to Amazon.
Check File Upload procedure here
The 2nd step
is to authenticate the Amazon sites for which inventory needs to be controlled
Please find the instructions in the following sub menu
The 3rd step,
Once Authentication is complete for all the Amazon sites,
Please navigate to 'Selling Venues' in 'Settings' for each selling venue aka Channel, click on the following check boxes and click on "Save" button.
Option#3a 'Enable Order Download (Authentication Required)'
Option#4a 'Enable Inv Adjustment (Feed Inv Qty from ChannelMAX)'
Option#4c 'Check orders for inventory Synch (Authentication Required)'
Option#4c should not be checked if you want to manage orders using ChannelMAX. You would need to uncheck if using ChannelMAX Order Management
Enabling option#4e would update the SKUs not in ChannelMAX from your Amazon Seller Central.
The 4th step,
ChannelMAX Administrator will then schedule the inventory Synch process. Once process is setup, ChannelMAX will auto download your orders so that your inventory will automatically be subtracted from ChannelMAX. All you need to do is to keep your inventory count up to date in ChannelMAX, using 'Unified --> Inventory'.
The 5th step,
You can check historical record of your inventory quantity change using 'myInventory --> Inventory Adj Report'.
 
File:Settings - Inventory mgmt Setup.jpg
 
File:Inv-ADJ-Report.png

Inventory integration between Amazon FBA and EBay

We have many sellers requesting that ChannelMAX keep eBay inventory in synch with the inventory quantity available in Amazon FBA for same SKUs. ChannelMAX can do this, ChannelMAX schedules a job that auto imports Amazon FBA inventory and update the downloaded qty into EBay. If the FBA SKU falls to zero qty, then we remove the listing from EBay and when the listing is back in FBA, the listing is re-listed.   We set up a job in the following sequence

 
  1. import all missing listings from eBay
  2. download latest FBA quantities from Amazon, say FBA SKU-1 has qty of 10, update that to ChannelMAX
  3. download eBay orders, if FBA SKU-1 sells one in EBay, the qty in CMax will be now 9.
  4. adjust eBay inventory, feed 9 for the FBA SKU-1 to eBay.
 
EbayOrderD EBAY-IMPORT 9999 CMAX
AMZNOrderD GET-FBA-ITEMS 9999,loginname,300,USD CMAX
EbayOrderD EBAY-ORDERS 9999 CMAX
EbayInvAdj INV-ADJUSTMENT 9999 CMAX REGULARDUMP
 

SKU is not imported when "Check orders for inventory synch" is checked

To make sure that wrong inventory in not fed to Amazon, when "Check orders for inventory synch", SKUs not already in ChannelMAX will not be imported. You will have to upload to ChannelMAX.

Inventory Management Across Multiple Sites (Advanced)

As part of advanced inventory management, you may use ChannelMAX inventory allocation profile, found in 'Settings--> Inventory Profile'.

Inventory Management Across Multiple Listings, same physical item

Question

I have multiple listings of the same physical item on Amazon with SKUs such as: widget-a, widget-b and widget-c. Lets say I have qty 10 of this item - can your software make it so that each listing shows qty of each item then when any one of them sells, your software makes all 3 listings show qty 9? Thank you.

Answer

The answer is yes. This is how it's done in ChannelMAX.

  1. In ChannelMAX, we call these SKUs (widget-a, widget-b etc.) of the same physical item as sibling SKUs.
  2. As step-1, you will need to define a dummy SKU in ChannelMAX called "widget". This dummy SKU will be labelled as MasterSKU. This SKU will not be listed in Amazon or any other selling venue. It will simply be used as an umbrella to group the sibling SKUs.
  3. In step-2, you will define SKUs widget-a, widget-b and widget-c with "widget" as their master SKU, (see the screenshot below)
  4. When any one of the 3 SKUs sells, then all the sibling SKUs will be deducted with the sold quantity and quantity for all 3 SKUs will be re-adjusted back to the selling venue. In the above example, when widget-a sells 1, then it will subtract 1 from each of other two sibling SKUs and ChannelMAX will feed 9 for all 3 SKUs back to the selling venue.
  5. To update inventory quantity for all the siblings SKUs in one go, you need to simply update the inventory of master SKU and quantity will be propagated to the children SKUs.
 

File:Master_sku_panel.jpg

 
In the following diagram, [template file may be downloaded here]
(1) A01 is the master SKU, hence no MinSellingPrice or ASIN needed, but Title is needed
A01-A/A01-B/A01-C are the children of this master SKU A01,
hence MinSellingPrice as well as ASIN are needed, but Title is not needed
MasterSKUControlsInv is Y, meaning that if any of the sibling sells, qty is deducted from all.
MasterSKU is not selleable, hence ASIN is not present
 
(2)C-01 and D-01 are independent SKUs, and not part of any MasterSKU
 

File:Mastersku-upload-sheet.jpg

I wanted to constantly keep inventory quantity of 5 in ChannelMAX ?

Question

Is there a way in ChannelMAX so that my quantity in Amazon always shows as a fixed number ? For example, I always wanted to keep my quantity at 5 for specific SKUs.

Answer

Yes. ChannelMAX can help you in that. You will have first create a new folder in ChannelMAX and move your desired SKUs to that folder. Please email that folder name to ChannelMAX. ChannelMAX will setup the job.

Please understand the downside to it:

Say your actual inventory in 100. ChannelMAX keeps feeding 5 all the time to Amazon. If you sell out, ChannelMAX will still keep feeding until and unless you remove that SKU from that specific folder. So we recommend that you do this only if you have unlimited quantity.
The second drawback is that buyer may want to buy 10 pieces together, and if you maintain 5, you will potentially lose that sale.

Inventory Management: Half.com

ChannelMAX can maintain your Half.COM inventory, addition, update and deletion. What price to be fed to Half.com is set by defining a repricing model using 'myInventory --> AMZN Reprice Rule' named "Half.Com-Default" and set rule#35 to what value you need, such as "120%" or "Item Unit Cost"

Bundling of SKUs, unbundling while shipping

Question

I want to know if there is an option in CM that allow us to sale bundles. Now we are selling 3 different items individually ( A, B, C ), but we created another SKU ( XX )that is a bundle of these 3 items . So when we sale the SKU ( XXX ) does it will automatically deduct these units .

Answer

Yes. To do this in ChannelMAX, you need to first define all the 4 SKUs, A, B, C and XX. Then search sku XX using 'myInventory --> Inventory'. Select the SKU and click on 'Merge Items' at the bottom. In the invoked popup, fill SKUs A, B and C with quantity of 1 and click on 'Save'. When SKU XX sells, the inventory 3 SKUs A, B or C are deducted by sold quantity. What is bundling..

Feed Retail Price When Qty goes to Zero

Question

We have come across a problem with items that are out of stock for some time and then come back in stock with a higher price. Since out of stock items are not re-priced, how to solve this problem ?

Answer

ChannelMAX provides an option where by when an item gets out of stock, ChannelMAX will feed retail price to Amazon so that when the item has stock again it will not be selling below your new higher floor. To do this please

  1. Login to unified.channelmax.net
  2. Click on 'Settings'
  3. Click on 'Selling Venues' and choose as appropriate
  4. Check "Feed Retail Price When Quantity is zero"
  5. Click on "Save Inventory Settings"
 

File:Settings - Inventory mgmt setup 4b.jpg

What is needed for EBay inventory management ?

For ChannelMAX to manage inventory quantity for your eBay account:

  1. The first and foremost, you will need to make sure that "Custom Label" (aka SKU aka Merchant-SKU) assigned to your inventory in EBay. This can be done in many ways, one of them is EBay Selling Manager Pro, you may also use EBay turbo lister or Blackthorne. Please see the screen shot below ..
  2. Once its assigned, you need to authenticate your EBay account in ChannelMAX. ChannelMAX
  3. Once authenticated, ChannelMAX will auto download your EBay inventory.
  4. Screenshot-1 demonstrates how it looks in EBay Selling Manager Pro
  5. Screenshot-2 demonstrates how for the same SKU, "EBay" and "Amazon" is captured within ChannelMAX
 

Screenshot-1

File:CMax-EBay-SM-Pro-Inventory-CustomLabel.png

 

Screenshot-2

File:CMaxInventory-ebay-amazon.png

How to display "Custom Label" (aka Merchant SKU) column using "Selling Manager" in "Active Listings" page

  • Within your eBay account hover over the Activity tab and select Selling Manager.
  • Click to view all your eBay listings.
  • Click the "Customize" link on the top right corner of the active listings page
  • The "Customize active listings" window is displayed, check the Custom label box and then click Apply.
  • An additional column named "Custom label" is now displayed for your listings where you can edit listing SKUs one-by-one. Edit each product and save.
Note: eBay has a character limit of 50 characters for the custom label, but MUST keep it within 30 chars as other marketplaces allows less characters
 

File:EBay-Custom-Label.jpg

 

How to add items to Amazon using ChannelMAX ?

  • ChannelMAX now have the ability to add new items to your Amazon Seller Central. This feature is enabled to Amazon locales such as Amazon US/UK/CA/IT/ES/DE/JP etc.. along with other non-Amazon locales such as Play.com, and Sears.
  • Earlier, every time when you add item to Amazon, you had to do it by login to Amazon Seller Central and upload the information manually. But now, with ChannelMAX you have the ability to do the same work with the help of unified --> File Uploader. Below is how you may go about it..
a) As a first step, create a file containing the following information in tab delimited text format.
  • SKU
  • ASIN
  • Quantity
  • Price
  • SellingVenue
  • FBA (Optional)
PS: FBA column should have value Y for FBA SKUs and N for merchant fulfilled.
b) Once the file is created, you will have to upload it to ChannelMAX using 'Unified --> File Uploader'.
c) In unified.channelmax.net --> Settings, you may click on 'Selling Venues' and then click on the desired Selling Venue for which you would like to use this feature.
d) Then, you may tick mark option#4d as shown in the following image, scroll down to the bottom of the page and click on 'Save Inventory Settings' to enable this feature.
 
File:Settings- Add new item.jpg
 

How to keep FBA qty up to date in EBay?

Following are the steps to keep EBay inventory in sync with Amazon FBA.
Step1
Please make sure that following options are configured in ChannelMAX.
a) In "unified.channelmax.net -->Settings--> Selling Venues--> Ebay US", option#4a, 4e and 4F may be tick marked.
Please refer the image below.
 

File:Enable option 4 for inv mgmt.jpg

 
b) In unified.channelmax.net -->Settings--> Selling Venues--> Amazon US (or any other appropriate Amazon locale) options#5a, 5b and 5c may be tick marked as shown in the following link.

File:Option 5 for inv mgmt.jpg

Step -2:
Then, identify how many EBay SKUs are in ChannelMAX inventory and how many of them are FBA.
a) Login to unified.channelmax.net
b) Click on "Inventory"
1 Click on yellow color funnel icon
2. Select ebay US under Selling venues
3. Click on red color go
4. Then, select FBA filter in inventory screen
5. Click on green color 'Go'
You may refer to the following screenshot.

File:Ebay fba inventory.jpg

Step - 3
Below is how to verify the quantity available for ebay and Amazon.
a. Search by SKU/ASIN in "Inventory" dashboard.
b. Click on + sign near SKU and expand
c. Click on 'Ads' tab
d. Note the Qty in CMAX
e. Click on 12 digit listing ID in 'Launched' column below 'H'.
PS: Clicking on the listing ID will direct you to ebay product info page for that specific SKU.
Now, match the quantity available in ebay, which should be matching with the qty displayed in CMAX inventory.
For the items already ended in Ebay and with FBA qty > 0, we would NOT re-list because duration (aka Days) for those listings are "10 days", it should be GTC (good till cancelled) in Days column.

File:Verifying qty in ebay.jpg

How to update Re-Order quantity

A) You may update the "Re-Order" quantity by uploading a file to ChannelMAX via "Unified --> File Uploader" screen. The file may have the following columns.
a. SKU
b. SellingVenue (Should be populated with appropriate SellingVenue)
c. ReOrder Quantity
B) Another option is to update "Re-Order" quantity manually in ChannelMAX Inventory by following the steps provided below.
Open Google Chrome or Fire Fox
Log into unified.channelmax.net
Click on "Inventory"
1. Search by SKU or ASIN
2. Click on pencil icon under column 'Qty'
3. Input appropriate value in "Reord.Qty"
4. Click on grey color floppy disk icon to save the changes.
PS: If quantity (green color) in ChannelMAX Inventory falls below Reorder quantity, email alert will be generated.
You may refer the image below...
 

File:Reorder qty.jpg

How to Search the SKUs with certain Re-Order quantity

1. Login to Unified.channelmax.net
2. Click on "Inventory"
3. Navigate to filter present at the left hand side of the screen
4. Enter the value under 'δReord'
5. Click on green color 'Go' to view the results

Please note, if the Quantity in green (Master Qty) is 10 and the Reorder Quantity is 4 for an item, you may input the value as 6 in "δReord".. It would provide you the result as the difference between Master Quantity and Reorder Quantity is 6.

 

File:Filter by reord qty.jpg

When does the inventory related CHANGE get updated

a) Whatever the changes take place in inventory i.e, when the sale happens in ebay/Amazon or any other Selling venues or the master qty is adjusted in inventory are updated every 30 minutes in CMAX.
b) This is reflected under "Inventory Adjustment Report" which is shown when clicked on green color Master Qty in Inventory.
c) But, complete dump of inventory would happen every 12 hours.. Hence, the changes made under "myInventory --> Inventory Allocation Profile" would take about 12 hours time to reflect the changes in the corresponding Selling Venue.
 
You may refer the image below...
 

File:Inv adj report.jpg

 

How to add Child SKUs to Master SKUs

A) Open Google Chrome
B) Login to unified.channelmax.net
C) Click on "Inventory"
1) Search by SKU (that is, the SKU which need to be considered as MasterSKU)
2) Click on "Setup Master/Child SKU'
3) Enter the SKU which need to be associated with MasterSKU
3) Click on "Add to Master SKU"
4) Click on 'Yes' in the Confirmation panel as shown below.
 

File:Add child sku to master.jpg

 

PS: The SKU which need to be considered as Child SKU must already be present in CMAX inventory to associate with MasterSKU.

How to edit Min/Max values in 'Master SKU Panel'

Search by MasterSKU in 'Unified --> Inventory'
1. Click on 'Setup Master/Child SKU'
2. Click on pencil icon
3. Enter new Min/Max values or MAP or Actual Shipping Cost
4. Click on 'Save'.
 

File:Edit min-max in master sku panel.jpg

 

How to set Master SKU Inventory Control

Search by MasterSKU in ' Unified -> Inventory' dashboard.
1. Click on 'Setup Master/Child SKU'
2. Click on value Y under column Q
3. You may choose 'Qty is controlled by Master SKU' to control qty of child skus. This is the default setting
4. You may choose 'Qty is not controlled by Master SKU' if you do not want a specific child SKU qty controlled with it's MasterSKU qty.
5. You may choose 'Remove this SKU from this MasterSKU' to disassociate child SKU from MasterSKU.
6. You may choose any of these 3 options and click on 'ok' to save the changes.
 

File:Master sku inv control.jpg

 
Personal tools