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.

 

Share:

How to Track Sales on Amazon from External Traffic Sources Using UTM Codes and Storefront Brand Pages

How to Track Sales on Amazon from External Traffic Sources Using UTM Codes and Storefront Brand Pages.

 

Here’s an example of a storefront sub page. I’ve made this UTM link in case any of you buy this product after clicking, it will track the conversion: https://www.amazon.com/stores/page/53EDB83F-0F7D-4211-B01F-1A319FE00068?channel=MyAmazonGuyDemo

To create a source tag, watch this video.

Steps below:

  1. Go to the store page in Seller Central

2. Click on Insights.

3. Click on Create Source Tag


 
 
 
 
 
 
 
 
 
 
 
 
 
4. Here generate the tag, add a word for the campaign in question, like “Facebook”

Share:

How to launch and sell a product on Amazon, getting the your first sale

In this video I go over the basics of getting your first sales on Amazon, building traffic, conversion, and more.

10 codes for 90% off the Hakuna Moscato Wine Glass by Momstir:

WP3X-JKWNW2-G6CFA2
WPZR-GF2DXU-SXGNAU
WPSZ-5AUA5V-M3YEAC
WP96-2C8WYR-76QHAM
WPX3-ECBRB6-YANXAK
WPFK-KVBQ6M-5XGAA6
WPRU-2ZD47U-T9UGAQ
WPHM-M5YUVA-AK2FAT
WPPS-C4J89W-JC4UA8
WP89-ULKRT5-ERENAM

http://myamazonguy.com/contact

 

Share:

Amazon promotions vs coupons vs sales (Strikethrough pricing no longer works)

There are a few options you have to drive to convert your traffic better using promotional tools. While it’s easier to double your traffic than it is to double your conversion rate, there are times called for that you want to discount. Below are the options available to you.
  1. Promotions – no cost, but are somewhat hidden and not easy to find. I chose this option because you are driving external traffic and you can simply say, 40% off, just add to cart, no promo code needed. One benefit to this is you can have unique promo codes used for external traffic and track which external source got the sale.image.png
  2. Price reduction/sale – no cost, but no strikethrough, customer can’t tell it’s on sale. We simply reduce price. This does trigger the camelcamelcamel followers, and conversion goes up with a lower price often. But customers don’t really know it’s lowered as compared to when it was higher.
  3. Coupon – Costs 80 cents a click. Very visible, clip to get the coupon. Shows in search results and top of product page. There is no tracking with this tool, you just know number of coupons clipped and used.
If the promotions don’t work, I’d suggest coupon next. Coupons I prefer to use if there’s not external traffic being used. With external traffic, you can educate the consumer and avoid the cost of a coupon.
Coupons
Share:

How to get approved for multiple Seller Central Amazon accounts

Many entrepreneurs have a legitimate reason to open up multiple Seller Central accounts on Amazon. They might have unique businesses and multiple business owners that don’t share stakes in every venture. As a consultant, we’ve come across this need many times. Below is information that is requested by Amazon to get you this approval.

IMPORTANT – Do not open a 2nd account until you have been approved. You risk suspension that takes 1-3 months to resolve if you don’t get approval first.

Steps to open a 2nd account:

On the Contact Us form, select “Account Settings” and then the “Other account issues” sub-category:

https://sellercentral.amazon.ca/gp/contact-us/contact-amazon-form.html

Main information requested by a team that allows multiple Seller Central Amazon accounts:

1.  Provide an explanation of the legitimate business need for a second account
2.  Have an account in good standing with excellent Customer Metrics
3.  Have a separate e-mail address, credit card, and bank account for the new account
4.  Not intend to sell the same products in both accounts

 

Additional information that may be requested:

– When was your business started?
– What are your yearly sales?
– Do you have any retail brick and mortar locations? If so, how many?
– How many employees do you have?
– Does your business have a website? If so what date was it created and can you provide a link?
– Do you sell on any other online selling platforms?
– What are the sources of your inventory? Can you provide an invoice from your primary supplier in support of this?
– What are your anticipated monthly sales on Amazon?
– Have you got adequate inventory levels to meet the demand you foresee for sales on Amazon? Is this stock readily available for dispatch?

Share:

Enhanced Content A+ EBC Amazon Strategy Tips & Tricks Keywords

Below are some links to helpful information on EBC/A+ Enhanced Content.

In depth guides:
Good Content Examples:
Main Methods:
  1. Add 1000+ words of copy
  2. Keywords in copy, headlines
  3. Keywords in alt text of photos (behind scenes)
  4. Take up space, decrease noise from competitors and other Amazon elements that don’t help your sales
  5. Organize information in a pyramid with the most unique product information at the top, product grid in middle and category information in middle, and brand story at bottom.
  6. Recommend using custom templates to build as you have assets available.
  7. Copy the templates over to other products.
Goals:
  1. Increase total keywords ranked for
  2. Increase keywords rankings to be higher ranked to page 1
  3. Increase traffic to listing
  4. *Enhanced content has not made much of an impact to conversion rates for most sellers – and is thus seen as more of a traffic play*
Share:

Amazon Parentage Child Variations Explained, Strategy Behind BSR & Keyword Ranking Connections

Parentage is complicated. I explain why you need to set it up.

 

When splitting a parentage, the reviews will split as well, whatever child had the reviews keeps them. If you are combining children into a new parent, reviews will combine together. I predict sometime in 2019 parentages will no longer share reviews and only independent children will host their own reviews.

 

Rankings are shared in most categories nowadays between children, via BSR rankings. The best ranking child ranking is shared among the others. We do not feel this impacts other children directly for ranking purposes other than additional sale generation to weaker variations. Simply having a better rank does not appear to impact sales however. When splitting children from a parentage, each child would have its own ranking. As for keyword rankings, these are shared when parented, and split when separated as a child as well.

 

Based on our experience, it’s best to launch a new product as follows. Attach it to a historically performing well listing as a variation, for a short time period of 2-4 weeks. Even if the other variation has bad reviews. Run a viral launch and generate buzz. Break the parentage right after the marketing drive. And let the new listing stand alone if it’s newer/better. The keyword rankings it gains from both of these actions is substantial. Launching new flavors/variations of well performing products is a good idea. Typically if more than one variation is doing really well I often split them out so they gain more search traction for the brand. But if there’s a star variation, and the rest are weaker, I keep them together. The example above is how I try to make a new star variation on a launch.

Share:

How to Launch Amazon Products in Europe in 2019

How to sell in Europe Amazon 2019

Launching Amazon Products in Europe is easier now than ever before. Launch in Europe to grow your customer base and brand recognition!

There are five European Marketplaces: UK, Germany, Italy, France, and Spain.

Here are the five steps to being ready to launch across the Atlantic in 2019:

1. Obtain a VAT in UK. (This can be done through companies like Regional Express or Regional Shipping and typically takes 2-3 weeks.)
2. Create an Amazon Europe Account.
3. Create your listings.
4. Ship inventory FBA to UK.
5. The products will ship to all 5 European Marketplaces from there through a program called Pan-EU Fulfillment. A prime badge is awarded.

 

Benefits:
– New, global customer base
– Get your feet in emerging markets
– Additional top-level sales
– Can price however you’d like
– You can be a US entity with a US Bank account

Costs:
– Cross-border fees
– VAT registration fees
– European Consumption Tax at 20%
– Monthly account fee
– European trademark (Optional)

– You do not need a European Entity, but you will be paying quarterly taxes that can be outsourced to a tax consultant.
– You do not need a European bank account. You can use your US bank account.
– The 5 Amazon European marketplaces are used by the entire continent.
– Listing items in Europe can be tricky due to translations and EU regulations. Example: Medical Claims have to always be backed up in Europe.
– Use tools like https://www.deepl.com/en/translator to translate copy over to other languages.
– Brand registry setup is the same as in the US except you need a European Trademark that can be obtained through a company like Avast.

– Germany is the biggest marketplace, followed by the UK.

– Since there is a 20% across all of Europe as duties in a consumption tax, you can generally raise the price of your product up 20% to negate this cost. The European customers are generally understanding.
– If you’re selling supplements or topical items, you will need to clear a category gating. This is normally solved by providing images of the box along with a Certificate of Analysis.
– There is a monthly fee for Amazon Euro that covers all 5 marketplaces.Amazon Europe

Amazon has representatives that can help you with this process. One of the reps is Krista Tse (kristse@amazon.com).

Share:
Scroll to top