hide this box
Need 1 on 1 help w/ Ryan? I'd be more than happy to help πŸ™‚
Click here to book one today. Subject to availability.
Get Ryan's Help BOOK NOW »
Free Dropshipped Print on Demand training

How to Bulk Edit Handling Time On Amazon

By on

I walk you through how to bulk edit your handling time for dropshipped print on demand items in Seller Central in preparation for the end of year sales rush.

Your sales should see a massive spike following Thanksgiving/Black Friday, as customers begin shopping in preparation for the holiday season.

As a result, your fulfillment partners may experience a slowdown in their production times for your goods (Gearbubble especially).

In order to protect your Amazon account, we may need to extend out handling times to account for the potential delays. Otherwise, you might occasionally see this email from Amazon:

Amazon email indicating late shipment of customer order

* click to expand

(You never want to see one of these)

When I receive one, it means I forgot to update my handling times...

How to Bulk Edit Listings On Amazon

The purpose of this article is to share how to bulk edit handling times, but you can also easily update both Price & Quantities at the same time as well.

* Note: this gets a bit technical, but it shouldn't deter you from performing the steps in order to protect your Amazon account.

  1. Create an active listings report by going to Inventory > Inventory Reports
    Navigate to inventory reports in seller central

    * click to expand

  2. Request & Download the Active Listing Reports (it may need to process for up to 5 minutes)
    Request inventory report in seller central

    * click to expand

  3. In Google Drive, create a blank Google Sheet
    Create new google spreadsheet

    * click to expand

  4. Click on File > Import & upload the Inventory Report. Set the separator type to "Tab"
    Import inventory report into google sheets

    * click to expand


    Upload inventory report to google sheets

    * click to expand


    Import inventory report & set separator type to tab

    * click to expand

  5. After the data loads, right click & delete the first row
    Delete first row of inventory report

    * click to expand


    Delete row in google sheets

    * click to expand

  6. Click the data tab & sort by column A from A to Z
    (This makes it easier to remove products)
    Sort column a from a to z

    * click to expand

  7. Delete any SKU that you DO NOT want to change.
    I typically edit listings together per fulfillment partner. Gearbubble listings start with the prefix "GB", while Printful listings begin with "PF".
    Only leave the SKUs in that you intend to make changes to
  8. Next we need to create an upload spreadsheet, using a template provided by Amazon.
    Go to Inventory > Add Products via Upload
    Click add products via upload under the inventory tab in seller central

    * click to expand

  9. Under the "Download an Inventory File" tab, scroll down to the "Inventory Files" section & download the "Price & Quantity" template (you can click here as a shortcut)
    Download an inventory file tab

    * click to expand


    Inventory updates section

    * click to expand

  10. Click the "Download the Price & Quantity file template." link
    Download Inventory Flat File from Amazon

    * click to expand

  11. Open the Price & Quantity file that you just downloaded in either Google Drive or Excel
    (If you want to edit in Excel, make sure both files are open in Excel & vice-versa)
    The "Data Definitions" tab is open by default - switch to the "Price Template" tab
    Click the price template tab

    * click to expand

  12. Alternate between your sorted inventory report file & the inventory file - move your data over one column at a time
    DO NOT COPY HEADERS (Only copy the DATA!)
    Select all data in a column by clicking the heading

    * click to expand


    You can select all data from a column by clicking the column header (for example, click "A" to select everything)
    Note: If you get an error "we can't paste because the copy area and paste area aren't the same size", then copy the values manually (don't click the column headers)
    Column A: SKU - Move to "sku"
    Column B: ASIN - (ignore)
    Column C: PRICE - Move to "price"
    Column D: HANDLING TIME - Move to "handling-time"
  13. After all of the required columns are ported over, set the "handling-time" column to the integer value representing the # of days (I currently use 14 days for Gearbubble during the holidays & 10 days for Printful)
    example of filled out inventory report
  14. Save the Price & Quantity as "Text (Tab delimited)"
    Save your price and quantity file as tab delimited text file

    * click to expand


    if you used Google Sheets, you may need to save as .xlsx & open in Excel in order to save as Text (Tab delimited)
  15. The last step is to upload our Price & Quantity file. Go back to Inventory > Add Products via Upload & click the "Check & Upload your Inventory File" tab
    Click add products via upload under the inventory tab in seller central

    * click to expand


    Check and upload your inventory file

    * click to expand

  16. DO NOT use the "check inventory file for errors" function.
    If there's errors when you upload, it will let you know via email.
    Proceed with your upload in the "Step 2: Upload File" section
    Upload your price & quantity report

    * click to expand

  17. That's it!
    I typically receive an email indicating that it finished processing within 15 minutes
    Amazon email indicating batch up load was successful

    * click to expand

It's always best to play it safe and bulk edit your handling time for the holidays.

Your Amazon account grows in value as you add more SKUs to your dropshipped print on demand offerings. Don't get greedy with handling time - you and I have no control over how long it takes our fulfillment partners to ship out orders.

Keep in mind that you can (& should) reset your handling times after the holidays are over. Save this article and use the same approach to bulk update your Amazon listings.

Better safe than sorry!

» Read more about Dropshipped POD «

Lets Connect

Comments