Trend Analytics: Product Cost Update via File

Update via Files Feature

This feature allows users to efficiently manage product cost-related data by utilizing bulk upload and export functionalities.

To access the feature,

1. Go to Trend Analytics page.
2. Locate the Update via Files button in the Product List section.
3. Click the button to access the bulk options.

What are the actions that can be performed?

Download Product Cost

• This allows users to download a file that includes the product list and the corresponding product costs.
• A template file with the following data will be downloaded:
  • Seller ID
  • Marketplace
  • ASIN
  • SKU
  • Product Cost
  • MSRP (Manufacturer’s Suggested Retail Price)
  • Max Discount Ratio
  • Max Surcharge Ratio
• If a value doesn’t exist, it will be represented as “0”

Upload Product Cost

• This allows users to upload a file to update the product list and the corresponding product costs.
• Users should use the template and fill in the fields:
  • Mandatory Fields: Seller ID, Marketplace, ASIN, SKU, Product_Cost
  • Optional Fields: MSRP, Max_Discount_Ratio, Max_Surcharge_Ratio
• If a mandatory field is missing, an error will be displayed.

Upload/Download History

• This allows users to track past downloads or uploads in the Upload via Files feature
  • Download History contains the following information: User, Request Time, Complete Time, Status, File Link
  • Upload History contains the following information: User, Request Time, Complete Time, Status, Updated Records, Failed Records, Error File Link, File Link

What are the possible issues/errors a user may encounter?

Failed SKUs

• If any SKUs fail to update, the users should:

1. Download a new template containing only the failed SKUs.
2. Review the errors and update as necessary.
3. Re-upload the file with the corrections.

Users also have the option to reset the form in case of failed SKUs. If the “New” button is clicked, this will clear the previous uploads and reset the form.

Upload Failed

• If the upload fails, this may mean that mandatory fields are missing. If this happens, the user should ensure that all the required fields are filled out before uploading the file.

Incorrect Data Format

• This may mean that the wrong template was used. If this happens, the user should ensure that the template used is the one provided in the “Upload via Files” button.

Export File is Empty

• This means that the template doesn’t have any information available. The user should verify that the product data exists in the system.

Eva always strives to make your lives easier. With this feature, updating the product costs should be easier!

Need More Help? Let Our Team Guide You To Success!