Talk:FriendlyTools

From ChannelMAX

Revision as of 09:30, 24 September 2015 by Cmaxwiki (Talk | contribs)
Jump to: navigation, search

Contents

UPC WebSearch tool

Manual Search

You may use this simple WebSearch tool to find/generate report from Amazon on demand. Below steps shows how you can manually find the results for UPCs using this 'Websearch-->Search' tab.
1. Choose the 'Site' as desired.
Note: You can get the results only if these sites(aka marketplaces) are connected under Settings-->Selling Venues section with appropriate Amazon merchant ID.
2. Choose exact search parameter such as UPC
3. Enter UPC code value in the text field
4. Click 'Search Amazon'
P.S: Similarly, you can make use of other search parameters such as EAN, ASIN, Keyword as appropriate.
 

File:UPC Search new.png

 

Fileupload

If you have a few hundreds of UPCs or ASINs to be searched on Amazon, you may upload a file in tab delimited text format containing 2 columns, ASIN and SKU or UPC and SKU or Keyword and SKU.
When you prepare the file for uploading, please make sure that the first column(column A) value is always the search parameter that is, ASIN/UPC/EAN/Keyword and second column(column B) should have SKU values.
Once the file is prepared, you may choose appropriate 'Site' and then upload this file by clicking on 'File Upload-->Search Amazon'.
When this search process is completed, you may download the results into a text file using 'Download-->Add All-->Download to a text delimited file'.
 

File:Websearch Fileupload.png

 

File:Search download.png

 

Please note, when you perform this search, if your application is timed out or internet is disconnected or you log out of ChannelMAX application for some reason, the search process that is running would be terminated. If any of these situation arises, you will have to restart the process with new upload. If you intend to do bulk search with thousands of records, you may use alternate bulk search Run In Background.

Run In Background

Now we have a new way to bulk perform this search under WebSearch using Run In Background tab. This process as the name suggest runs on background and you need not keep the web screen open to complete this search. Once you upload any of the search files, such as ASIN/UPC/Keyword, process will run under background and once completed, resultant file link will be generated under 'Output' column with R link. You would also get a copy of this result file to your email address saved in your account under Settings--> Account Info page with the link such as http://www.repricer.net/WebSearch/users/loginname/301/loginname-asin-search-out-201504141532.zip

Below is what you need to do to perform this search.

  1. Click on WebSearch icon under ChannelMAX Unified and then on "Run in Background" tab.
  2. Select the appropriate selling venue.
  3. Under 'Type' column click on 'Choose' next to ASIN and select the search file from your computer which is created as a .zip file.
  4. Click in Initiate.
  5. Once the search is complete you would see the timestamp under "EndTime" column.
  6. Click on 'Output' column to download the resultant file.
When this search file is prepared, please make a note of the following points:
  1. First column(Column A) in the file should be SKU and second column (Column B) should be UPC or ASIN or Keyword.
  2. Each of the file name that you upload should be in the the format {loginname}-{type}-search.zip.(if login name is demo001 and for ASIN search, file name should be demo001-asin-search.zip)
  3. After creating the files as above, file should be saved in tab delimited text format and then zipped before uploading the file to ChannelMAX as per point#3 provided above.
You may refer to the following screenshots for better understanding.
 

File:CMaxWebsearch-V2-Choose-Upload1.png

 

File:CMaxWebsearch-V2-Running.png

 

File:CMaxWebsearch-V2-Complete.png

 

File:CMaxWebsearch-V2-Output-Download.png

 

UPC Search FTP Option

This is an alternate option for bulk search. You may have a list of UPCs that need to be searched in Amazon for detailed information. Doing it one by one can be a daunting task. ChannelMAX allows you to mass search Amazon for list of UPCs as per the following steps:

Step-1
Please obtain following FTP credentials from your web-hosting company.
FTP URL
FTP Login ID
FTP Password
 
Step-2
Login to unified.channelmax.net
Click on 'Settings-->Dropship-->My Own FTP'
Input FTP details in Section-5
Click on 'Save'
You may validate FTP details using Net2FTP
Step-3
Create a tab delimited text file named [channelmaxloginname]_upc.txt containing the following two columns
SKU
UPC
P.S: When file is prepared make sure that column A is SKU and column B is UPC.
Step-4
Put this file in your FTP location, not in any sub-directory.
Step-5
At the same level where the file in step 3 is uploaded, two folders should be created:
Processed: Once the file is processed, it will be moved here
Inbound: The resultant file will be uploaded to this folder
Step-6
Once the above 5 steps are completed, please contact ChannelMAX via support ticket and our administrator will setup a job on ChannelMAX's server to process this file.
Once the UPC Search report is generated, you would receive the file containing the following columns
1) UserID, 2) LoginName, 3) Site, 4) MerchantSKU, 5) UserCustom1, 6) UserCustom2, 7)UPC, 8)EAN, 9)Category, 10) Binding, 11)ASIN, 12) Manufacturer, 13) Mpn, 14) Model, 15) Width, 16) Length, 17) Height, 18) ListPrice, 19)SalesRank, 20) TotalOffers, 21)BuyBoxSellerName, 22) :BuyBoxPrice, 23) BuyBoxShipping, 24) Amazon-Like-Price, 25) Title, 26)ImageUrl, 27) Description, 28) Feature1, Feature2 etc.. upto 5 features, :lowest 5 sellers information like Seller names, Condition, Price, shipping and few other additional information would be captured in the output file.

Here is how the result file will look like.

 

File:Result File new.png

 

ASIN Search FTP option

We can process the list of ASINs that you would like to search in Amazon for detailed information through FTP setup. Here are the details of this setup. Please follow the steps carefully,

Step-1
Please obtain your own FTP
FTP Url
FTP Login ID
FTP Password
Step-2
Login to unified.channelmax.net
Click on 'Settings'
Click on'Dropship' and
Click on My Own FTP and
input the FTP detail in Section-5
Click on 'Save'
You may validated your FTP detail using Net2FTP
Step-3
Create a tab delimited text file named [channelmaxloginname]_asin.txt containing the following two columns and email the file name to ChannelMAX
SKU
ASIN
Step-4

Put this file in the FTP location, not in any sub-directory.

Step-5

At the same level where the file is placed, you need to have two folders

  1. Processed: Once the file is processed, it will be moved here
  2. Inbound: The resultant file will be uploaded to this folder
Step-6

ChannelMAX administrator will setup a job on ChannelMAX's server to process this file. The job will look like this.

 

File:ASINSearch_Schedule.png

 
 

File:UPCSearchFileInFTP.png

Once the report is generated, you would receive out file containing the following columns
1) UserID, 2) LoginName, 3) Site, 4) MerchantSKU, 5) UserCustom1, 6) UserCustom2, 7)UPC, 8)EAN, 9)Category, 10) Binding, 11)ASIN, 12) Manufacturer, 13) Mpn, 14) Model, 15) Width, 16) Length, 17) Height, 18) ListPrice, 19)SalesRank, 20) TotalOffers, 21)BuyBoxSellerName, 22) :BuyBoxPrice, 23) BuyBoxShipping, 24) Amazon-Like-Price, 25) Title, 26)ImageUrl, 27) Description, 28) Feature1, Feature2 etc.. upto 5 features, :lowest 5 sellers information like Seller names, Condition, Price, shipping and few other additional information would be captured in the output file.

Searching Amazon by KeyWords

Many times you may be looking for the list of ASINs from Amazon by a manufacturer name. For example, all products sold in Amazon manufactured by Sony or Samsung or Kyocera. How to get it is a question. ChannelMAX keyword search process makes it easy and helps you identify the ASINs associated with the items along with lowest 5 sellers selling price including shipping. This should certainly benefit you to decide on what products could be added to your inventory and get some dollars out of it. In the FTP file all we need is just input SKU, key word of the products along with the manufacturer name. Below is the instructions to be followed to setup this Keyword Search process.
Step-1
First and foremost you need to have an FTP account, which is provided by your web hosting company. Once you have FTP login credentials, you would have to save it under "Settings-->Dropship-->My Own FTP-->Section- 5".
Please refer this image below.
 

File:FTPcredentials Sec5.png

 
Step-2
You may create a tab delimited text file named "<CMAX login name>_keywordsearch.txt" containing the following columns.
A) Mandatory columns:
SKU
Keyword
B) You may up to 8 additional columns such as:
Supplier
Cost
Manufacturer
MPN
Example:
A) Manufacturer = sony and Example MPN = ABC123.
B) Then keyword must be "sony ABC123" (without double quotes), i.e., Manufacturer name and MPN separated by space.
Step-3
Put this file {<CMAX login name>_keywordsearch.txt} in the FTP location, not in any sub-directory.
Step-4
At the same level where the file is placed, you need to have two folders
Processed: Once the file is processed, it will be moved here
Inbound: The resultant file will be uploaded to this folder
Step-5
Once above steps are complete, ChannelMAX administrator will setup a schedule to process this file.
 

Customized UPC or ASIN or EAN or Keyword Search Results

When we process these Search reports and provide you the resultant file, it will contain over 40 columns with lot of data. However, all these information at times may be not required for you. Hence, to provide you a simple flat file with only what is needed our technical team have enhanced the system so that, you can define your own template to retrieve resultant file for UPC or ASIN or EAN or Keyword search FTP processes. This file should be created and uploaded to ChannelMAX using 'File Uploader' icon with the following naming format without clicking on any of the upload buttons such as A, B, C at the bottom of 'File uploader' screen.
upcsearch-template.txt (For UPC Search)
eansearch-template.txt(For EAN Search)
asinsearch-template.txt(For ASIN Search)
keywordsearch-template.txt(For Keyword Search)
In the above template file you can make use of any of these macros provided below:
  1. [#USERID#]
  2. [#LOGINNAME#]
  3. [#SITE#]
  4. [#SKU#]
  5. [#USERCUSTOM1#]
  6. [#USERCUSTOM2#]
  7. [#USERCUSTOM3#]
  8. [#USERCUSTOM4#]
  9. [#USERCUSTOM5#]
  10. [#USERCUSTOM6#]
  11. [#USERCUSTOM7#]
  12. [#ITEMCONDITION#]
  13. [#RETAIL#]
  14. [#UNITCOST#]
  15. [#MAP#]
  16. [#UPC#]
  17. [#EAN#]
  18. [#CURRPRODUCTGROUP#]
  19. [#PRODUCTGROUP#]
  20. [#BINDING#]
  21. [#ASIN#]
  22. [#IMAGEURL#]
  23. [#MFG#]
  24. [#MPN#]
  25. [#MODEL#]
  26. [#WIDTH#]
  27. [#LENGTH#]
  28. [#HEIGHT#]
  29. [#SALESRANK#]
  30. [#TOTALOFFERS#]
  31. [#TITLE#]
  32. [#DESCRIPTION#]
  33. [#FEATURE1#]
  34. [#FEATURE2#]
  35. [#FEATURE3#]
  36. [#FEATURE4#]
  37. [#FEATURE5#]
  38. [#SIZE#]
  39. [#COLOR#]
  40. [#DEPARTMENT#]
  41. [#ADDLATTRIBUTES#]
  42. [#ASINPARENT#]
  43. [#VARATIONCHILD#]
  44. [#LISTPRICE#]
  45. [#LOWESTFBA#]
  46. [#LOWESTNONFBA#]
  47. [#BUYBOXTOTAL#]
  48. [#BUBOXSHIPPING#]
  49. [#BUYBOXFBA#]
  50. [#AMAZONPRICE#]
  51. [#AMAZONFEEDBACK#]
  52. [#IMAGESETURL1#]
  53. [#IMAGESETURL2#]
  54. [#IMAGESETURL3#]
  55. [#IMAGESETURL4#]
  56. [#IMAGESETURL5#]
  57. [#BROWSENODE1#]
  58. [#BROWSENODE2#]
  59. [#BROWSENODE3#]
  60. [#BROWSENODE4#]
  61. [#BROWSENODE5#]
  62. [#BROWSENODE6#]
  63. [#BROWSENODE7#]
  64. [#BROWSENODE8#]
  65. [#BROWSENODE9#]
  66. [#BROWSENODE10#]
  67. [#VARATIONCHILD#]

Note1: IMAGESETURL and BROWSENODE1 are premium (For future use).

Note2: Macro [#VARATIONCHILD#]: If the ASIN is parent, then Variation Child is returned. File returns as "B0012133^color:black;size:medium*B0012144^color:black;size:large". Each child ASIN is returned with variant attributes such as color and size and each ASIN is separated by * sign.

For example, if you want to retrieve the file with only limited details such as ASIN, Buybox price, sales-rank and LowestFBA sellers price then the template file "asinsearch-template.txt" created should have only the following macros in it along with column headers such as UserID for macro [#USERID#], ASIN for [#ASIN#], Salesrank for [#SALESRANK#] etc..

  1. [#USERID#]
  2. [#LOGINNAME#]
  3. [#SITE#]
  4. [#SKU#]
  5. [#ASIN#]
  6. [#SALESRANK#]
  7. [#BUYBOXTOTAL#]
  8. [#BUBOXSHIPPING#]
  9. [#LOWESTFBA#]

UPC Optimizations report

For a specific UPC, there may be multiple ASINs available in Amazon. However most of the time, seller may not list on all the ASINs available for that specific UPC. Did you ever try to find out if for the same UPC (aka same item) you are not listed on all the ASINs available in Amazon ? ChannelMAX can help. ChannelMAX can find all the ASINs that you are not listed based on the UPC of the ASIN.

For example, these two ASINs share the same UPC# 843163010109, BlackBerry Skin for BlackBerry

B0014A4F5Q
B000OES0R2

If you list on one, but not the other, you will potentially miss out a sale.

To get UPC Optimization report, please do this

Login to unified.channelmax.net
Click on "Settings"
Click on "Selling Venues" and then choose appropriate Amazon site
Check "11(a). Find ASINs that share my UPC but I am not selling. "
Click on 'Save Special Reports Settings'
 

File:Settings-UPC optimization.jpg

TAG a seller (Newly added ASIN report)

I am sure you always wished to be notified on a daily basis what new ASINs/SKUs your competitor has added to Amazon to sell. Well this can be a reality now. ChannelMAX can help.

Report all ASINs sold by a seller

Do you want to know all the ASINs sold by your competitor including if FBA or not ? ChannelMAX can help you. If yes, please email ChannelMAX the seller's 'At A Glance' page. Example of 'At A Glance Page' is http://www.amazon.co.uk/gp/help/seller/at-a-glance.html?ie=UTF8&seller=AAM4ZWRLVTZFJ

Personal tools