Invalid File Format – Hazmat Exemption Sheet Upload Error

exemption sheet invalid file format amazon seller central hazmat dangerous goods upload error

You may have run into this error while trying to upload an exemption sheet for Amazon FBA hazmat, “Invalid File Format“. This error occurs because of one of two reasons.

  1. File Format: Amazon recently changed its file format to an excel version instead of a PDF. Submitting the wrong file format could cause errors. We have provided links to where you can download this new version below.
  2. File Name: The Invalid File Format error will still occur if your filename has a special character in it. These special characters include (<>\/|.:”‘?*&@). Remove these characters and your file will upload.


exemption sheet invalid file format amazon seller central hazmat dangerous goods upload error fix resolved solved

Exemption Sheet for Products without Harmful Chemicals

Exemption Sheet for Battery and Battery-powered Products

Exemption Sheet Upload Page


For more tips and tricks on how to grow sales on Amazon, reach out to My Amazon Guy and book a coaching call!

How to Create an Amazon Giveaway on Seller Central

Amazon has released a new giveaway feature under promotions that allows you to giveaway up 30 units. In addition to 30 units given away, there will be a 30%-40% off promotion for people who enter the giveaway and do not win. The seller will choose how many units for the giveaway and the percentage off promotion. Amazon will handle the target audience, selection of winners, and shipment of prizes. Below is an example scenario of how this giveaway promotion works.

The seller has chosen to give away 10 units for free in addition to anyone else who enters the giveaway to get 40% off. Amazon will select 1 person every 1200 entrants and send them their free unit. You can select how often Amazon will giveaway 1 unit when setting up the giveaway. On one product you could select every 3000 entrants 1 unit is given away while on another product every 1500 entrants 1 unit is given way. This varies for each product and depends on its metrics. People who did not get selected to receive a free product will be given the 40% off promo code. 

About 3,000 people will enter the giveaway and 6,000 people will see it. This can help get a few sales in the door and gain exposure on selected products. It is especially useful when wanting to push a product.

In our experience, we recommend starting with giving away 2 units of 2 different SKUs (products). We’ve found that it’s been the right number to start out with. Below is what Amazon’s giveaway page looks like and where your product will show up. 

Amazon Giveaways

How to create a giveaway in Seller Central:

There are two parts to setting up a giveaway. First, you’ll need to create a percentage off promotion for the product being given away. After creating the promotion, you’ll need to set up the giveaway and link the promotion to it. I’ll cover each step in granular detail below.


Navigate to promotions by hovering over “Advertising” on the top taskbar and clicking on “Promotions”. Once on the promotion tab, click “Manage Product Selection”. 


Now click the “Product Selection Type:” drop-down menu and select “ASIN List”. Then click on “Create Product Selection”. 



Here you will list the ASIN in which you are creating the promotion for along with a name and internal description. Submit the product selection and go back to the promotions tab. 


Now click on “Create” under “Percentage Off”.


This will take you to the promotion creation page. Under step 1 click on the drop-down for “Purchased Items” and find the product selection you just made.


Now you will need to give the percentage off amount. The max percentage for a giveaway is 40%. However, if this was not a promotion for a giveaway then there is no limit to the percentage amount. When entering the percentage off amount, do not use the “%” sign. Only use numerical values as shown below. 


Once you have your conditions set, you’ll need to set a date range and name it. Note this promotion has to be longer than 9 days or you won’t be able to link the promotion to it. You can set the date range by clicking on the start and end dates. Name this promotion under internal description. This name will not be customer facing but a reference for you to remember what the promotion is. 


Under additional options, you will set the claim code as a group claim code. You can either limit customers to one redemption per customers or allow them to redeem it more than once. This is done by checking or unchecking the one redemption per customer option. Set the claim code compatibility to unrestricted. This allows the customer to have multiple items in their cart. This will not apply the promotion to other items in the cart. Click review and submit your promotion. The promotion will take 4 hours to go live from the start date. 



Now that the promotion is set up, you’ll need to set up to giveaway and link the promotion to it. Do this by going back to the “Create a Promotion” tab under “Advertising” and click on create under “Giveaway”.


Find the product you are going to giveaway and click on “Set up a giveaway”.  This will take you to the giveaway set up page. 


Once on the giveaway set up page, you’ll need to enter the number of units giving away and your seller name. The max amount of units you can give away is 30 units. I recommend starting with a 2-3 unit giveaway.


To maximize exposing your product, select “Lucky Number Instant Win” as the giveaway type and select the lucky number. In this example giveaway, we are given 3 lucky numbers; 400, 500, and 600. You can only choose one. If we select 400 as the lucky number then that means ever 400th entrant 1 unit will be given away. So if we give away 3 units then 1 unit will be given away on the 400th entrant, 800th entrant, and 1,200th entrant.


You can make all entrants watch a video or follow an author on Amazon to before participating in the giveaway. Keep in mind this can limit the number of entrants, to maximize the number of entrants it’s recommended to select no additional steps to enter. 


Click “Yes” on the offer discount to entrants option. Here you’ll need to get the promotion ID of the promotion you created previously. The promotion ID can be found by viewing the promotion. Copy over the promotion ID and validate it in the giveaway. This will link your promotion to your giveaway so all entrants get the discount. 

Select “Public” as the discoverability and click next the proceed to check out.

Amazon makes you pay for the units you are giving away. If you are giving away 3 units then you’ll pay those 3 units at full price. This will then show up as a sale in your seller central account. Any units that are not given away will be refunded back to you.

Once you complete the check out process, it will take 8 hours for your giveaway to go live and Amazon will send you an email with a link to view your giveaway. You can also click here to view your giveaways. This completes setting up your giveaway!

If you need further assistance you can contact us here.

How to View Inventory Age and Excess Inventory on Seller Central

If you have too much inventory at Amazon you will be paying storage fees.


FBA long-term storage fees

On the 15th of each month, Fulfillment by Amazon (FBA) conducts an inventory cleanup. On these dates, inventory that has been in US fulfillment centers for more than 365 days incurs a long-term storage fee (LTSF) of $6.90 per cubic foot or a $0.15 per-unit long-term storage fee, whichever is greater.

As announced in the 2019 US FBA fee changes summary, we are eliminating long-term storage fees for units that have been in a fulfillment center for 181 to 365 days. The last long-term storage fee charge for inventory in a fulfillment center for 181 to 365 days was January 15, 2019. This change is not retroactive. Any previous 181 to 365 day charges will not be reimbursed.

Note: Inventory enrolled in FBA Small and Light remains subject to LTSF charges on units in fulfillment centers between 181 to 365 days. See FBA Small and Light for current LTSF rates for these units.

Long-term storage fees, February 15, 2019, and after

Inventory cleanup date Items in a fulfillment center more than 365 days
15th of every month $6.90 per cubic foot


So to help alleviate those storage fees, you should look at the inventory age and create removal orders on bad inventory.

To find inventory age click on “Inventory Planning” under the “Inventory” tab.


This will take you to the inventory dashboard. Here you will click on “Inventory Age” to view how many days each product has been at Amazon’s warehouse. To view overstocked items you can click on “Manage Excess Inventory”.



Then to do a removal order click

And click the edit drop down to do a removal order.















If you need more assistance contact us here.

How to Create an LTL shipment on Amazon Seller Central

LTL (Less than truckload) shipments are useful when you need to send large or multiple units into Amazon’s warehouses. Below I’ll cover how to create an LTL shipment.

First, you will need to select the product(s) you want to ship in. Do this by going into your inventory and checking the checkbox next to the product(s) you will be creating a pallet shipment for. Then navigate towards the action drop-down menu on the upper-lefthand side and click on “Send/replenish inventory”.


This will direct you to the shipment creation page.  On this page, you’ll want to select “Case-packed products” as the packaging type. This packaging type will help lower your chances of having your product(s) sent to multiple fulfillment centers.


Continue with the shipping plan and enter the box configurations. This means the number of units per box and the number of boxes for each product. Click continue. less than truckload shipment on amazon


The next page will ask you who preps the products. Some products are required by Amazon to be poly wrapped or bagged. If your products are required to be prepped then you have to either select “Merchant” or “Amazon” under who preps. If you choose “Merchant” then you are responsible for prepping your products. If you choose “Amazon” then Amazon will prep your products and charge 0.50 cent per unit. If your products are not required to be prepped then you can leave as is and continue to the next step in the shipment process.

Note: Amazon will let you know if your products require prepping. 


The next page is similar to the previous step. You will need to tell Amazon who will apply labels to the product. You have an option to apply the labels yourself or pay Amazon to apply the labels. If you choose Amazon, it will cost 0.20 cent per unit. If you choose to apply the labels yourself, click the print label button. This will download a pdf file with the number of product labels you need. In the example shipment, I have 40 units. This means I’ll be given 40 product labels, 1 product label per unit. Product labels need to be applied to the product itself.


The next step is a review of your shipment. Here it will tell you where your shipment is being sent. You also have the option to name your shipment. I recommend naming and dating the shipment for record purposes. After naming your shipment, click on “Approve & Continue”. Now you can work on your shipment!


After clicking the “Work on shipment” button, you’ll be directed to the final step in the shipment process. In this step, you’ll need to tell Amazon if this shipment is an SPD (Small parcel delivery) or an LTL (Less than truckload). Since you are shipping as LTL you’ll also need to confirm the box configuration, give pallet dimensions, print labels, and schedule a pickup date.

Select LTL and keep the shipping carrier as “Amazon-partnered Carrier”.


Under “how will the shipment be packed?”, select multiple boxes. Here you will need to confirm the box configuration by entering the shipment quantity again. Now click confirm and generate box labels.

Box labels will need to be applied to the outside of each box. In the example shipment, I have 40 boxes. This means I’ll be given 40 box labels to print, 1 box label per box. Box labels will always be applied by the merchant. 



In the next step, you will need to enter your pallet dimensions and weight. But first, you’ll need to get your pallet built out and weighed. After entering the pallet configuration, you can schedule a pick up ready date. This is not the day your pallet will be picked up but rather the day you let the freight forwarder know that your pallet is ready for pickup. Pickup usually takes around 3-7 days after scheduling the pickup ready date. The BOL will auto-generate a day before the freight forwarder comes to pick up your pallet. Once you receive the BOL, this means your pallet will be picked up soon.

Agree to the terms and conditions and accept the charges. If you’ve already accepted charges but need to make changes to the shipment then you have 1 hour after accepting charges to cancel the shipment. If it has been over 1 hour, then the shipment is locked in and cannot be canceled. 


Now you can download and print the pallet labels. You will be given 4 pallet labels per 1 pallet. These 4 pallet labels will go on each side of the pallet. Make sure this label is on the very outside of the pallet so the driver can scan the pallet labels when picking up your pallet. This completes your LTL shipment!

If you need any assistance with Amazon shipments, contact us here!

How to Set Up a Jump Send Account

Jump Send is a tool for Amazon sellers that allows them to promote products on an Amazon deals marketplace with over 100,000 users. Many Amazon sellers use Jump Send when launching their new products, since it’s an affordable way of marketing your products and promotions. Jump Send also offers an e-mail autoresponder feature, which allows you to automatically follow up with customers in order to ask for product reviews and feedback. Follow our steps below to set up your account and get started with Jump Send, or contact us about Jump Send setup and promotion management.


Go to and click Sign Up.

Choose Seller Account and fill out the form. Make sure to choose the appropriate subscription plan, this should have been decided upon before starting the process.


Next, you’ll have to connect your Amazon Marketplace account with Jump Send.

Verify you are on the admin account, if you go to user permissions, you can check to see if you are on the admin account by looking at the permission boxes on the right hand side. If you do not see an option to delete the profile, you are on the admin account.

To find the MWS Auth Token, log into your Seller Central account and navigate to the User Permissions page in the Settings.

connect your amazon account to jumpsend. from amazon, click on settings, and click on user permissions.


Scroll to the bottom of this page and locate the Third party developer and apps section, from here click on Visit Manage Your Apps.

add a third party app or developer to amazon seller central by clicking on visit manage your apps.


Once on the Manage your apps page you should be able to add the developer credentials given by the Dev Platform, in this case, Jump Send. You will need the developer ID and the name. Click on Authorize New Developer to add this information.

amazon seller central manage your apps page. view your developers or authorize a new developer from this page.


After you add Jump Send, you should see the Developer listed as an authorized developer.

To the right of the developer row you will see a small blue link, labeled View, under the MWS Auth Token column.

Click on View and you will be presented with your MWS Auth Token in the same cell.

amazon seller central mws authorization auth token with seller id, marketplace id, and mws auth token.

Jump Send will need your MWS Auth Token and Seller ID to sync all your products and allow you to create promotions and e-mails.



After enabling your seller account on Jump Send, you set promotions for the inventory. Click Promotions in the upper right-hand corner, then Create New.

Choose the product from the table or search by ASIN if there is a large catalog.

Enter the product description if it does not auto populate from Amazon.

Set the Product Category and click the radio button to use a keyword targeted url, only utilize the first 2 keyword fields. Verify the Keyword to ensure it works.

jumpsend promotion setup. amazon keyword targeted super URL with up to 3 keywords.


Protect Inventory: Select Yes for inventory protection. Set the order quantity to 1 and 99 on the dropdown box for “After the promotion, Limit order quantity:”

Set the start and end dates.


Create the Promotion on the Amazon side and insert the claim codes into the Jump Send Step 4) Create Coupons menu. Promotions take at least 4 hours to go into effect. Watch our Youtube video for help on creating Amazon promotions.


In the next step,  choose Automatic Approval, and approve up to half the total amount of coupons per day.

jumpsend create a new promotion step 5. choose between manual approval and automatic approval.


Finally, review the promotion and then launch!


How to Set Up Your Share a Sale Merchant Account

Share a Sale is an affiliate marketing network that simplifies the process of finding affiliates to advertise your brand and products. You pay a one-time fee to join Share a Sale, and from then on, you only pay when affiliates deliver actual results. Grow your online sales and traffic with affiliate marketing by joining Share a Sale’s merchant network. Follow our steps below to set up your Share a Sale account. If you need additional help, contact us about our Share a Sale setup services.


To begin, you will need some picture assets that follow Share a Sales’s perimeters:

the photos required to set up a share a sale merchant account


The next step will be to set up the legal agreement between you and your affiliates.

share a sale program agreement and PPC restriction rules for merchants. required during sign up.


Setting the tracker on your e-commerce site:


Log into Share A Sale: and then click step 4 to begin the tracker installation. Depending on which shopping cart you use, you will get a set of instructions on this page underneath the selection.

how to add a tracking code on share a sale. choose your shopping cart from shopify, woocommerce, bigcommerce, and magento.


Follow Share a Sale’s instructions to install the Pixel. Some prefer to have their web developer or admin complete this step.


After you install your pixel, you will have to test the tracker installation. We advise you create a $1 dummy item on your store page to use for the test as the transaction will go all the way through as if you were a customer buying an item on your website.

share a sale merchant setup step. test your tracing code by placing a full transaction.


The final step is the Fee and Payment Deposit. Once this is complete, you are ready to start setting your banners and approving affiliates. Contact us to inquire about banner setup and Share a Sale management. 


share a sale merchant account setup. fee depost. 550 setup fee plus minimum 100 dollar deposit.

How to Add a New Amazon Marketplace to Feedback Genius

Feedback Genius is a tool by Seller Labs that can automate feedback e-mails sent to customers after they order your product on Amazon. E-mails send with Feedback Genius increase the likelihood of receiving product feedback. You can also use Feedback Genius to track reviews on your products.


Follow our step-by-step directions to connect your Amazon marketplace to Feedback Genius. If you need help or want to save time, contact us about setting up Feedback Genius for your Amazon seller central account.


Log into feedback genius and click the dropdown next to your email and click settings.

Connect your amazon marketplace to feeedback genius. start by clicking settings on feedback genius.


Next you want to click Marketplace Settings

connect amazon marketplace to feedback genius by clicking on marketplace settings.


Click Add New Marketplace

amazon api authorization for feedback genius. click on add new marketplace.


Then Click Start Setup

seller labs amazon marketplace api connection. click start setup to connect your amazon account.


Click Connect North American Account

connect your amazon account to seller labs. click on connect north american account.


Then you will go through the motions of verifying MWS to connect your Seller Central account to Feedback genius.

How to Set Up an eBay Seller Account

ebay logo. set up an ebay account with my amazon guy.Selling your products on multiple marketplaces is one of the easiest ways to remain competitive in the e-commerce world. After Amazon, eBay is the second largest online marketplace in the United States. Expand your reach to an additional 179 million shoppers by following our steps to create an eBay seller account.




Need help setting up or managing your new eBay account? Contact us to learn more about our eBay services.

eBay Account Setup Instructions

  1. Go to the registration page.
  2. Enter your name and email address.
  3. Choose a password.
  4. Select Register (By selecting Register, you’re agreeing to accept the terms of eBay’s User Agreement and User Privacy Notice).


eBay will then send you a welcome email, with tips on how to get started.


Select Business account on the registration page. They’ll ask for some additional details, like your business name, type, and address.

If you are a US based seller with inventory outside the US, you may have additional tax obligations. You can find more information about these possible obligations, in the Seller Center.


How to Verify Your eBay Account

Before you can start buying, eBay will ask you to verify your email address. They’ll send you an email to the address you entered when registering with further instructions.

Opening an additional eBay account

Some members find that having more than one account is a convenient way to organize a large number of items, or to sell different kinds of items.

If you do open additional accounts, you’ll need to use different usernames and email addresses. Please be aware that you can’t use more than one account for activity related to the same listing (for example, you can’t bid on the same item from multiple accounts, or bid on an item you’re selling from another account). Also note that if one of your accounts becomes suspended, all of your accounts may be affected.

If you want to move an email address from one eBay account to another, you’ll need to remove it from the first account and wait 60 days. Then you’ll be able to add that email address to another eBay account. Learn how to change your email address.


How to Set Up a Payment Method

When you create a seller account, you’ll need to add a payment method to pay for any eBay selling fees or charges. You can choose PayPal, direct debit, or credit card as your payment method.

  1. Go to your Account in My eBay.
  2. Look for Payment methods for seller fees and select Change automatic payment method.
  3. Choose your preferred payment method from the dropdown menu.
  4. Select Set up automatic payments.

If you choose to pay by PayPal, you’ll be redirected to the PayPal site to complete the process. If you choose direct debit or credit card, you’ll need to enter your bank or card details.

If you choose direct debit or credit card, you’ll need to enter your bank or card details. They’ll need to verify your card so if it’s declined during verification, while making payment, or at some other time, you’ll need to contact the issuer of your card.

How to make a one-time payment

You can make a one-time payment on your eBay seller account using PayPal, direct debit, credit card, check, or money order. Just be sure to make your payment at least 5 days before the due date. If you mail in a check or money order, it’s best to send it 10 days before the due date to allow for delivery time.

Because you’re required to have an automatic payment method on file, be sure you aren’t making a duplicate payment when you make a one-time payment for your fees.

You can make a one-time payment anytime. Here’s how:

  1. Go to your Account in My eBay.
  2. Look for Payment methods for seller fees, select one-time payment, and enter your payment details.


How to Set Up PayPal as a Payment Method

When you create a listing, just select PayPal as a payment method and enter the email address associated with your PayPal account in the Payment options section of the listing form.

You can also set up PayPal as your preferred payment method for all your listings. Select the button below, and then Tell Buyers that I prefer PayPal payments.


Remember, if you offer PayPal as a payment option on eBay (either using logos or text in the item description) you must accept all forms of PayPal payment including payments from an existing PayPal account balance, bank account transfers, and credit card payments. You can’t tell buyers that you’ll only accept specific forms of PayPal payment. See our Accepted payments policy for more information. When a buyer sends you a payment through PayPal, the money is usually available in your PayPal account right away. However, in some cases, the payment might be “pending” for a few days, or it might be held by PayPal for up to 21 days.

For sellers, there’s usually a fee for each payment completed through PayPal. Check with PayPal for current terms and conditions.


How to add products into an existing parentage via template on Amazon Seller Central

How to add products into an existing parentage via template

Working with parentages and templates can be somewhat intimidating since it’s more on the technical side which makes it prone to errors. No need to worry. Below I’ll break down how to add products into an existing parentage by template. It’s quite simple.

First, you’ll need to download the template. To do this go to your seller central account and follow the path, Inventory > Add Products via Upload > Download an Inventory File. Here you will select the category your product is in. You can either search for your category, using the search tool or manually find your category. Once you’ve found and selected your category make sure to change the mode from “Lite” to “Advanced”. Now download your template by clicking “Generate Template”.

Click here to be directed to this page.

On sight, the template may look complex but it’ll become simple as you work with it. If you want to learn more about how templates work then I recommend reading all 7 tabs on the excel sheet. The two main tabs used when working with templates are the “Template” and “Valid Values” tabs. Other tabs are informational.

Each column on the “Template” tab contains an attribute. We will be using the following attributes for adding products to an existing parentage.

  • item_sku – The SKU which you want to edit.
  • parent_child – The classification of the SKU. Either parent or child. (Valid Value)
  • parent_sku The assignment of the parent SKU to the child/children SKU.
  • relationship_type – The relationship between each product. (Valid Value)
  • variation_theme – How the products differ from each other. (Valid Value)
  • update_delete – How you want to update your product. (Valid Value)
  • size_name: – The size of the product.
  • color_name – The color of the product.

To learn more about attributes, read the “Data Definitions” tab. This tab will explain the use for each attribute on the template. Some attributes are valid values which means you can only select inputs given by the template. You cannot input whatever you want for valid values. The excel sheet will provide a drop-down selection for attributes that are valid values. You can also view the ‘Valid Values” tab. This will list all attributes with valid values and their selection. Note valid value attributes are case sensitive.

Example of the parent_child valid value.

If I want to add 3 t-shirts that differ by the colors red, green, and blue to my existing parentage that already has yellow and pink then I would do the following.

  1. On the “Template” tab, fill in the product SKUs and parent SKU under the column containing item_sku attribute.
  2. Next, scroll to the right until you find the parent_child column. If you look at the “Valid Values” tab and find the parent_sku column, you will see that this attribute can only be a “Parent” or “Child”. The products being added into the parentage are children while the parent SKU is the parent. Notice that the “Child” values are on the same row as the product SKUs and the “Parent” value is on the same row as the parent SKU.
  3. Next is the parent_sku attribute. You’ll need to assign the parent SKU to the children SKUs. This is done by adding the parent SKU next to the“Child” SKU. Notice you will never assign a Parent SKU to a Parent SKU.
  4. Now you’ll need to define the relationship_type attribute. Since this attribute is a valid value you can refer to the “Valid Value” tab for selection. This attribute can either be a “Variation” or an ”Accessory”. The ”Accessory” value will almost never get used since everything can be defined by “Variation”. Notice you only define the children SKUs just as before.
  5. Next attribute is the variation_theme. Here you need to define how the products differ. Since this attribute is a valid value lets navigate back to the “Valid Values” tab and look at what we can choose from. There are many different variation themes and they can change depending on the category. The most common variation themes are size and color. Almost all templates will have size and color as a variation theme selection. Since the t-shirts differ by color we are going to select “Color” as the variation theme. This has to be done for both parent and child SKUs.
  6. The next attribute is update_delete. This is another valid value attribute. You can either enter “Update”, “PartialUpdate”, or “Delete”. We want to use “PartialUpdate” since we are editing existing products and parentage. Partial Update will only update attributes you’ve entered values on. “Update” will update all attributes even if you’ve not entered a value for it. I recommend always using “PartialUpdate” when making changes. If not, using “Update” will rewrite all your data. The last selection is “Delete”. As the name implies, this will delete your listing.You will need to list “PartialUpdate” on both parent and child SKUs. This will tell the system that you want to make changes to your listings.
  7. The final attribute is color_name. Since we chose “Color” as our variation_theme we will need to enter the colors here. If we had chosen size as our variation theme then we would need to enter the size under the size_name column. Since this is not a valid value you can enter whatever value you want. Notice that the color names are on the same rows as the child SKUs. This will only be filled out for child SKUs.

This completes the template. The last thing you’ll need to do is save and upload your template to Amazon. To do this navigate to Inventory > Add Products via Upload > Check and Upload your Inventory File > Step 2. Make sure the file type is selected as “Inventory Files for non-Media Categories”. Next, you can upload your file, enter your email, select excel as the format and upload your template. Once the file is done processing, you will receive a processing report by email. This report will inform you if your template received any errors, warnings, or none at all. If you receive any errors then double-check all attributes and valid values.

If you need any assistance then contact us here.


Scroll to top