Invalid value provided for Weight Minor: Enter a value between 0 and 999 gm

Full error name: “Invalid value provided for Weight Minor. Enter a value between 0 and 15 oz. ErrorCode: 715“

May 3, 2023

Cause

eBay does not accept product weights over 999 g and/or 15 oz. If your product weighs over 999 g/15 oz, round up to 1kg/1 lb and try republishing the listing. 

Solution

How to convert the weight?

You can bulk-edit the weight via CSV. All you need to do is:

  1. Select the products in error.
  2. Click “Actions”
  3. Export .CSV file.
  4. Edit the weight.
  5. Upload the .CSV file back to Nembol.
  6. Retry the publication.

How to convert grams into kilograms using Excel formulas?

Amending product details via CSV implies a little bit of manual work.

However, the fastest way to do so is by using Excel formulas. We suggest proceeding in this way:

  • Open your CSV file.
  • Copy the whole weight column.
  • Open an empty sheet (this avoids messing up the CSV that we will need to upload back to the system)
  • Paste the column.
  • Next to the pasted measures, type this formula =CONVERT(A2;”g”;”kg”)
  • Once done, drag the cell to apply the formula to all sets of weights you copied in the empty sheet.
  • Now, you have all your weight converted from g to kg.
  • Copy the column.
  • Open the CSV file.
  • Click with the right button of your touchpad or mouse, and paste “Values”.
  • Now that you have all the weight converted, edit the unit measure in the CSV.
  • Type kg instead of g and drag the cell to apply to multiple cells.
  • Save and upload it back to Nembol.

When transferring data back to CSV, be sure that the columns and measures are not mixed up. Otherwise, you could attach the wrong data to your products.