• Product ID, the seller will indicate the GS1 Product Identifier. For more information check this thread. Please remember that the number of digits is crucial. A 14-digit code is a GTIN, a 13-digit code is an EAN, 12-digit code is a UPC, and so on so forth. Figure 1.6

• Product name, the title or product name must be short and to the point. Some categories even have a restriction on the number of characters. Spamming the title is a common problem that doesn’t help sellers for two reasons: first, it confuses buyers, second, there is no need to put search terms and keywords in the title when they can be added in many (many) more places. The product name is just that: the product name. It has to start with the brand, and then an extremely clear description of what the product is. For instance: “Tally Tony’s Boiled Peanuts, 12 oz” is an acceptable name. “Delicious snack, Hand-Harvested by THE Tally Tony himself, carefully measured to fit 12 oz bottles, with not an OZ to spare” is not an acceptable title, and it even fails to indicate what the product is.

• Manufacturer, the manufacturer of the product. (This attribute is not in every listing)

• Manufacturer Part Number, alphanumeric string that represents the manufacturer part number. This is a required field for Brand Registered products. (This attribute is not in every listing)

• Brand Name, one of the most important steps of the listing process is to link the Product with the Brand. Please review the considerations explained earlier on the thread on how to list products after the brand has been registered.

• Item Type Keyword, a value from a drop-down menu. (This attribute is not in every listing)

• Model Number, optional value, different from the name and the manufacturer part number. (This attribute is not in every listing)

• Unit Count, this value is important when calculating price per unit. It indicates how many units are being sold, and it is closely related to the next attribute (Unit Count Type). The Unit Count measures how many units are being sold. It is explained here.

• Unit Count Type, it refers to the actual unit of measure of the Unit Type. It can measure weight, area, volume, length, or quantity. (This attribute is not in every listing)

• Contains Liquid Content, a yes or no question. (This attribute is not in every listing)

• Size, an attribute closely related to variations. The Size indicates how different items compare. It can be a numeric or text value. It doesn’t refer exclusively to clothing; size is an attribute that can be used when comparing the size of tumblers (FL OZ) or when measuring the length of a digital screen. (This attribute is not in every listing)

• Size Map, predetermined value from a drop-down menu. (This attribute is not in every listing)

• Color, another attribute closely related to variations, color of the item. (This attribute is not in every listing)

• Color Map, a predetermined color from a drop-down menu. (This attribute is not in every listing)

• Number of Boxes, number of boxes on which the product is shipped. (This attribute is not in every listing)

• Is Product Expirable, a yes or no question. (This attribute is not in every listing)

• Product Expiration Type, a drop-down menu. (This attribute is not in every listing)

• Fulfilment Center Shelf Life, measured in days. (This attribute is not in every listing)

• Item Form, a drop-down menu. (This attribute is not in every listing)

• Number of Items, number of items included in the product. (This attribute is not in every listing)

• Fitment Type, universal product that can work for all brands (a car soap can be used in a Ferrari or a Lada) or specific to a given brand/model (charger specific to a given type cellphone). (This attribute is not in every listing)

This will be studied in detail in the Thirrd Section of this thread. This section can be ignored by sellers that are not creating a parent product but a standalone listing.

• Seller SKU, this is the SKU or identifier that the Seller uses to monitor the product. I have explained SKUs in length here. The SKU can be any value that the seller wants, anything from “IhateAmazon” to “Something_logical_and_easy_to_identify”. The SKU becomes an integral part of the listing, so it deserves a level of consideration. Again, I recommend checking the link provided above.

• Product tax code, explained here by Amazon .

• Merchant Shipping Group, the shipping template to which the listing is assigned.

• Restock Date, in case of backorder, is the date at which the product will be available. (This attribute is not in every listing)

• Standard Price, needless to say, one of the most important values. It refers to the price at which the product will be sold. For information on how to calculate this price check this link.

• Sale Price, an offer price. It has to be lower than the Standard Price.

• Sale Start Date, the date at which the “Sale Price” starts.

• Sale End Date, the date at which the “Sale Price” ends.

• Manufacturer’s Suggested Retail Price, also known as MSRP. Not all products have it, and it won’t be charged to the customers, but many products have a MSRP.

• Quantity, the number of units available for sale. This value is for items Fulfilled by Merchant, FBA sellers can leave it empty. Sellers should not list product that they don’t have available. Offering products that are not in stock is an accident waiting to happen, and a good way to cause damage to the account, either by cancelling orders, causing late shipments or simply frustrating buyers.

• Condition, a drop-down menu. Select if the item is new or used, and if used in what condition.

• Condition note, for used items, what the buyers can expect of the item.

• Max Order Quantity, the largest number of units a buyer can purchase in a single order.

• Handling Time, how many days it takes the seller to process the order.

• Offer can be Gift Messaged, a drop-down menu saying “true” or “false”.

• Is Gift Wrap Available, a drop-down menu saying “yes” or “no”.

• Offer Start Date, if a listing is created and product is not available, the seller can indicate a future date at which the item will be available. That way buyers can know when to expect the product. As a personal note, new sellers would do well to stay away from this attribute, it’s another accident waiting to happen.

Below these attributes sellers will see a table where they can control the Standard Price and Quantity in the different regions of a marketplace.

This is a complicated section that changes greatly from product to product. It becomes difficult to create a good list of attributes, so don’t be surprised if your screen does not list any of the ones I’m indicating. They can also be listed in a different order.

One of the best tools to determine the compliance of a product is studying its Safety Data Sheet (SDS). Of course, not all products have an SDS, but for those that do check this post to learn how to use it.

• Volume, a numeric value accompanied with a drop-down menu for units.

• Item weight, a numeric value accompanied with a drop-down menu for units.

• Watts hour per battery, a numeric value accompanied with a drop-down menu for units.

• Battery weight (grams), a numeric value accompanied with a drop-down menu for units (extremely funny that it has a drop-down menu for units given that the name of the attribute indicates grams, but whatever.

• Lithium content (grams), a numeric value accompanied with a drop-down menu for units.

• Categorization/GHS pictograms (select all that apply), check the link of the SDS, this information is found in the second section.

• Battery type/size, the type of battery from a drop-down menu.

• Number of batteries, how many batteries.

• Safety Data Sheet (SDS) URL, a website with the SDS of the product. It can be an URL external to Amazon.

• Lithium Battery Packaging, drop-down menu.

• Number of Lithium-ion Cells, a numeric answer.

• Number of Lithium Metal Cells, another numeric answer.

• Applicable Dangerous Goods Regulations, study in the SDS.

• Is this product a battery or does it utilize batteries?, drop-down menu with yes or no.

• UN number, listed in section 14 of the SDS.

• Battery Composition, drop-down menu.

• Batteries are Included, drop-down menu with yes or no.

• Flash point (º C)?, listed in section 9 of the SDS.

• California Proposition 65 Warning Type, listed in section 15 of the SDS.

• California Proposition 65 Chemical Names, listed in section 15 of the SDS. List all that apply.

• Pesticide Marking, drop-down menu.

• Pesticide Registration Status, drop-down menu.

• Pesticide Certification Number, please, please, please… don’t falsify this information.

• Radio Frequency Emissions & Authorization Status, drop-down menu.

• SDoC Contact US Phone Number (email, mailing address, and name), SDoC stands for Supplier Declaration of Conformity. If you don’t know what that is, or if you don’t have it, leave the following sections blank. You can ask your supplier/manufacturer. But as with all Hazmat information, please be careful not to invent it. The SoDC is a way to assure that a product complies with a given regulation.

• FCC ID, Federal Communications Commission ID number.

Fairly straightforward section. Just upload the pictures from your computer.

Make sure that the images meet Amazon requirements, particularly the main image.

Getting a perfectly white background requires software editing, there are many ways to do this. From Photoshop to online tools. This post (let alone this thread) is long enough without a tutorial on how to edit pictures. Maybe it can be added as a future post.

This, and the following section, are key for the discoverability of the product.

The “Description” section doesn’t have many attributes, but they all have repercussions on the impression that the listing causes.

• Product Description, sellers can’t use HTML to “pretty-up” this section up. This is a professional page, keep it professional. The description will be a block of text, sellers need to make it count. Explain things clearly, in detail, fully aware that 97% of buyers will not read it. The description can have a lot of information, but buyers are advised not to expand too much as it can create confusion. Remember that on average a buyer doesn’t spend more than 1 minute per page. You only have 1 minute to convince the buyer to purchase your listing, and by the time the buyer reaches the description 30 seconds have already passed by looking through the images, key features (below) and price.

• Key Features, when creating many listings sellers can add key features that will appear as bullet points between the product’s image and the price. Some categories (I think books) don’t have the option of writing key features. Key Features must be short, and to the point. Bursts of description that encapsulate what the product is and why it should be bought. Most buyers will spend more time in the Key Features than in the Description.

• Legal Disclaimer, any legal information that needs to be added. This can’t be something that the seller “pulls out of a hat”. A “Legal Disclaimer” implies that there’s a reason why this is indicated, and that reason is a law. For instance, indicating that according to such regulation the product is for people over 21 years of age is a valid legal disclaimer; indicating that Tally Tony’s Boiled Peanuts taste better when combined with Tally Tony’s Cashews is not a valid disclaimer.

• CPSIA Warning, drop-down menu with all the imaginable choking warnings.

• CPSIA Warning Description, the alphanumerical description that corresponds to the warning.

This is the section that should be used to make the product easy to find. All the terms that can spam and clutter title, description, key features, etc., that are relevant to the product but don’t fit anywhere else go here.

• Style Specific Terms, different lines that can be added. These terms are descriptive words that help place the product in the right categories. Do not use sentences; if necessary, sellers can use multiple words, but no more than that.

• Used for 1-3, drop-down menus with different applications, places of use for the product. Up to 3 can be selected.

• Target Audience, drop-down menus for the different target audiences by age and gender.

• Other Attributes, drop-down menu with other attributes.

• Search Terms , super important part that gets often overlook. The “Search Terms” are what get the discoverability of the product. Write the search terms but don’t repeat them (if a seller is listing a red sweater the seller shouldn’t say “sweater”, “red”, and “red sweater’), do not separate terms by commas, just by spaces. Terms can be miss-spelled to common typos and in different languages.

• Subject Matter, another important way to help the discoverability of the product is adding strings of keywords. Subject matter keywords are added in a similar way to the “Style-Specific Terms” explained above, sellers can enter up to 5 strings of keywords, each string with a maximum of 50 characters.

• Platinum Keywords, from a third-party seller’s perspective, for all intents and purposes this is an obsolete feature; it appears that Amazon may not have deleted this solely to maintain legacy compatibility with certain software used almost exclusively by members of the Vendor Program.

This is a super long section that I will not explain in detail. There’s no point. A seller that has completed all the other parts of the “Add Product” should be able to complete it. There are however a couple of sections that are worth mentioning:

• Shipping Weight, how much the packaged item will weight. Sellers can select different units.

• Dimensions and weight of the item, it is important to understand the difference between the item and the package. This section allows to list both.

• Package Quantity, how many units the buyer will receive each time an item is purchased.

• Launch Date, when the product will be available.

• Is Discontinued by Manufacturer, drop-down menu with “yes” and “no”.

• Cell A4 is a drop-down menu with only one option: cleanningaggent, we select that.

• Cell B4 is the item SKU, for the exercise we are working with TallyTony’s Unparallel Floor Cleaner 1 gallon, so we will say that the SKU is TTUFC1G. (As indicated above, I have explained my terminology for SKUs [here] (‼ Regarding GTINs and how to navigate the GS1 dashboard)).

• Cell C4 is the GTIN, let’s say is a 12-digit code 876543210987.

• Cell D4 is the Product ID type, as a 12-digit code is a UPC. This is a drop-down menu.

• Cell E4 is the Product’s name: TallyTony’s Unparallel Floor Cleaner, 1 gallon.

• Cell F4, Item Type Keyword, is a drop-down menu. Only one option.

• Cell G4, Unit Count Type, we could argue that it could be either “Count” (because we can sell multiple gallons) or we could use “FLOZ” because we are selling the item by volume. Price per unit is calculated by dividing by the Unit Count. I recommend using “FLOZ”, so that the listing will say $X/FLOZ. This is always attractive information that the buyers like to see.

• Cell H4 is Unit Count, a gallon has 128 FLOZ, so 128.

• Cell I4, Is Product Expirable, drop-down menu. It depends on the product, a floor cleaner really doesn’t expire, so I’ll say no, but if you want it to expire you can say yes.

• Cell J4, Main Image URL. Just copy the URL of the website where the image is. Let’s say www.TallyTony’sawesome. com/image/manydigitsthatdontmatter

• Cell I4, quantity, how many units are available for sale, let’s say 10.

• Cell L4, standard price, $12. I would love to sell for $10MM, but I would probably not sell very many units… Just write “12”, don’t include the dollar sign.

So, our file should look like what is shown in Figure 2.3

This is the easiest section, we already explained how to upload the “Main Image”. Secondary images follow the same rule. Copy the URL of the images from any website where you have them. That covers cells M-U 4. I’m not adding a Figure of that. It would just be rubbish and the thread is long enough as it is.

We will explain this in detail in the Fourth Section of the thread.

• Cell AC4, Update Delete, type of update we are doing, is a drop-down menu. We are creating the product so it’s a full update.

• Cell AD4, Brand name, TallyTony. It’s a drop-down menu. If the brand is registered and the seller is authorized to sell it, the brand should be listed in the menu.

• Cell AE4, Model number, TK421 (credit to whomever guesses what that code references from memory).

• Cell AF4, product description. Describe the product, I’ll accept any description that sings praises to my “Unparalleled Floor Cleaner”.

• Cell AG4, Manufacturer’s Part Number, you can leave this blank if you want, you can add a part number if you have it. In the grand scheme of things, it doesn’t matter, but it doesn’t hurt to have it. This information becomes important if you are selling a product that’s super specific, for instance car part; many buyers will still miss it.

• Cell AH4, Manufacturer, who did it? Well, of course, THE TallyTony.

• Cell AI4, GTIN exemption reason. I don’t recommend getting exemptions, but that’s just me.

The File should look like Figure 2.4

We reach a part a bit less intuitive and maybe more confusing, but still fairly straight-forward.

• Cell AJ4, Style Name, not really needed for this product, we can say “Floor Cleaner” if we wanted to. But neither adds nor subtracts. Can be left blank.

• Cells AK to AT 4, Key features that will appear as bullet points next to the product’s image. Super important part. We can say things like “Concentrated Floor Cleaner”, “Dilute 1/2 cup per gallon of water”, “Lavender Fragrance”, “Made in the USA”, “Peanut free!”. Whatever else you feel like, up to 10 bullet points, I personally recommend not using more than 5. It feels like trying too hard.

• Cell AU4, Equivalent Product Volume Unit, is a drop-down menu, for this case let’s select “gallon”

• Cell AV4, Equivalent Product Unit, as we selected “gallon” in the previous cell, let’s use 1.

• Cell AW4, Search Terms. Check above for the explanation on search terms. We will use things like: “Floor cleaner lavender concentrated”. Then misspelled words like “fllor or clnr” and we’ll throw some Spanish too “Piso limpiador concentrado”. All is fair in love, war, and search terms.

• Cell AX4, Scent name, I have decided it’s Lavender.

• Cell AY4, Color, if the fragrance is Lavender, it better be purple.

• Cell AZ4, Garment type, this isn’t clothing, so we leave this blank.

• Cell BA4, Number of boxes, we are only shipping 1 box, so “1”.

We can leave cells BB-BD 4 empty for the purpose of the exercise because they don’t apply to this product.

This is a wide section, so I had to zoom out, but it looks like Figure 2.5:

This section has a trick. I have fallen for it in the past. Check it carefully.

• Cell BE4, Item Width Unit of Measure, we’re in ‘Murrica, so let’s say “inches” (who measures sellable items in picometers?). This is a drop-down menu.

• Cell BF4, Item Form, completely unrelated to the previous cell. Another drop-down menu, we are selling a liquid.

• Cell BG4, Item Height Unit of Measure, another drop-down menu, for consistency “IN”.

• Cells BH and BI 4, finally are Width and Height respectively. It’s frustrating that they aren’t exactly next to the “unit” cells. Let’s say that the width is 6 (inches) and the heigh is 11 (inches).

• Cell BJ4, Item Display Volume Unit of Measure, another drop-down menu, we can use gallons or FLOZ. Let’s use Gallons here for the sake of the exercise.

• Cell BK4, Liquid Volume, this is a trick. This cell has nothing to do with the previous one. This cell is related to the next one (BL4). Thanks Amazon, this is why people hate the templates. Anyway, rant’s over. In BL4 we will select FlOZ so here we will select 128.

• Cell BL4, Liquid Volume Unit of Measure, we already ranted about this cell, is a drop-down menu, let’s select FlOZ.

• Cell BM4, Display Volume, this is related to cell BJ4, so here is 1, because we are offering 1 gallon.

• Cell BN4, Item Length Unit of Measure, drop-down menu, inches for the sake of consistency.

• Cell BO4, Length, let’s say 6 inches.

In short, not a difficult section to fill, just confusing because of how disorganized it is. It should look like Figure 2.6

It’s like the previous section, but here we are going to give the dimensions of the package that we will be shipping. Not of the item, the package.

• Cell BP4, Package height unit of measure, drop-down menu, inches.

• Cell BQ4, Package length…, guess what, nothing to do with the previous cell.

• Cell BR4, Package width, surprise, surprise! Nothing to do with either of the previous cells either.

• Cell BS4, Package weight unit of measures, drop-down menu, let’s say pounds.

• Cell BT4, Package height, this cell relates to cell BP4. Enter the height of the package.

• Cell BU4, Package width unit of measure. Relates to cell BR4. Drop-down menu.

• Cell BV4, Fulfillment Center ID, drop-down menu. Amazon-fulfilled means FBA, Default means FBM.

• Cell BW4, Package length unit of measure. Relates to cell BQ4. Drop-down menu.

• Cell BX4, Package weight. Relates to cell BS4.

So, this is a minefield. Sellers just need to be careful to relate the right cells together. It’s not hard, just tedious. It should look like Figure 2.7

This section goes forever. I’m not going to explain it cell by cell. If anybody is using the guide, by this point they need to know how it works. It’s a lot of drop-down menus and yes and no answers. Please check the “Compliance Section” on the section above to see what to input where. If the product doesn’t have batteries just select “no” and forget about all the battery related questions.

If the product has an SDS (a floor cleaner would) just add the URL and copy the information.

Again, this is just long, but straightforward. I have faith in you, you can fill it!

There’s no way to add a Figure that covers from column BY to EQ, so imagine that it’s filled.

This section has a couple of tricks, and it is a delicate one. Sellers are advised to fill it with particular care.

• Cell ER4, Gift wrap, drop-down menu.

• Cell ES4, MAP, whaterver the MAP is.

• Cell ET4, Package quantity, how many items per package, so in this case, 1.

• Cell EU4, Release date, whenever it becomes available, format MM/DD/YYYY.

• Cell EV4, Offer End Date, a bit out of place as we haven’t indicated the offer start date.

• Cell EW4, Currency, USD. This is why there’s no need to use the “$” sign when indicating price.

• Cell EX4, MSRP, just the price, no $ sign.

• Cell EY4, Product site launch date, format MM/DD/YYYY date when the product is shown on Amazon, but not necessarily available. This was described earlier on as an accident-waiting-to-happen. If you’re a new seller I suggest you avoid this.

• Cell EZ4, Max order quantity, let’s say buyers can buy up to 4 at a time. But that’s up to the seller. Setting a max order quantity can prevent a single competitor from “hoarding” all the inventory with a fake purchase and stranding it as “pending” for weeks.

• Cell FA4, Merchant shipping group, the shipping template associated with the item.

• Cell FB4, Offer start date, a bit out of place but what’s new? Goes with cell EV4.

• Cell FC4, Product expiration type, drop-down menu. This relates to cell I4 (no, I’m not joking)

• Cell FD4, Restock date, also described as an accident waiting to happen. You’re just learning to fill a basic template, don’t play with dates that you can’t control.

• Cell FE4, Number of items, this is redundant information, but let’s say 1, again…

• Cell FF4, Fulfillment center shelf life, how long can the product be on a shelf. Think of it as a “sell by date”.

• Cell FG4, Product tax code, again, explained above. This is indicated by Amazon.

• Cell FH4, Handling time, how long it takes for you as a seller to prepare an order.

• Cell FI4, Offering can be gift-messaged, drop-down menu.

• Cell FJ, Condition, better be new. I don’t allow arbitrage of my brand.

• Cell FK4, Condition note, only for non-new products.

• Cell FL4, Sale Price, only if there’s a sale.

• Cell FM4, Start sale date, finally something that’s in order.

• Cell FN4, End sale date, three cells in a row that make sense together!

It should look like Figure 2.8

Last section, this is not even needed, and I’ll confess, that even though I use the templates to upload products, I usually fix the B2B prices in the inventory tab.

• Cell FO4, Business price, $11, we input just the 11.

• Cell FP4, Quantity price type, drop-down menu, percentage or fixed. This is completely up to the seller, I like “percentage” better because it takes care of itself when I adjust the business price. Particularly in years with horrible inflation.

• Cell FQ4, Quantity lower bound 1, the first break, let’s say that if you buy 2 units you will get a discount. So “2”.

• Cell FR4, Quantity price 1, the discount. The percentage, say we want to give 5%, just type “5”.

• Cells FS, FU, FW, and FY are the next quantity breaks.

• Cells FT, FV, FX, and FZ are the next percent breaks.

• Cell GA, Progressive discount, is something that new sellers don’t really need to worry about. This is for FBA items that sell big quantities, so leave it alone. It works the same way as the cell FP4. Just use it for larger quantities. Drop-down menu for percent or fixed.

• Cells GH and GI are very rarely needed (definitely not for a floor cleaner)

• Cell GJ4, Pricing action, is a drop-down menu that serves to delete either the whole B2B pricing structure, the quantity price, or the progressive discount. Most times seller will leave this blank.

Figure 2.9 looks like this:

For the current example we will work with “Item package quantity”, as we want to do an offering (variation) for 1 gallon and 4 gallons.

Once we select this variation theme, the screen will undergo two changes, Figure 3.3:

image.png 975×620 140 KB

The first one is that the “vital info” and the “offer” tabs are no longer shown as missing information, while the variation tab is. The second is that now the screen alerts us (in bright red) that we need to create the variations.

To create the variations, we will simply input the quantities in the “package quantity” field. The quantities that we will use in this case are “1” and “4”. We will input them individually. Every time we add a number a new space is opened to include a following variation. It will look like Figure 3.4

image.png 974×534 133 KB

As we only want to create these 2 variations, we will simply click “Add Variations” and the bottom of the screen will add the table shown in Figure 3.5:

image.png 975×455 89.4 KB

Filling this table is not particularly complicated. The only thing needed is to have the Product IDs and prices of the child products. It’s not even necessary for them to already exist on the Amazon catalog, though if they exist, they can be linked to the parent simply by filling the information. If Amazon recognizes the Product ID, it will open a pop-up confirming that the seller is linking the right product to the Parent.

Once the information is filled, the screen will look like this, Figure 3.6:

image.png 975×463 73.7 KB

At this point the variation is technically ready to go live. The seller can just click “Save and Finish” and the variation will appear. Please read the final considerations regarding variations at the end of this post.

Let’s assume now that TallyTony’s Unparalleled Floor Cleaner can be sold in quarts and gallons.

If we return to Figure 3.2, we can choose the variation theme of “size”. This would prompt the screen shown in Figure 3.7:

image.png 974×609 137 KB

For size we can easily select “quart” and “gallon”. We will input the value just as we did for the previous example, and we will then click “Add Variation”. The screen will look like Figure 3.8:

image.png 975×438 90 KB

And once we fill the information, it will look like Figure 3.9:

image.png 975×463 70.1 KB

Again, ready to save. Please read the considerations in the bottom of the post.

For the final part of the example, we will create a double variation. We want to sell quarts and gallons, but we want to sell quarts as singles, 6-packs and 12-packs, and the gallons as singles and 4-packs.

From Figure 3.2 we select the variation theme “Itempackagequantity – size” and we will have a screen that combines the results of Figures 3.3 and 3.8. This new screen will have the expanding fields for both package quantity and size, and they will be used just as they were used in the previous examples. Figure 3.10:

image.png 975×618 134 KB

Please note that on the quantities we will list all the possible quantities (single, 4-pack, 6-pack, and 12-pack). Once we click the “Add Variation” button a table will appear showing us all the possible combinations of Package Quantity and Size. Sellers need to be careful to choose the right combinations. Figure 3.11:

image.png 975×459 85.7 KB

As it’s usually the case, this table is much more intimidating than it has to be. The first thing to remember is that some of those values are not going to be used (4-pack of quarts, 6-pack of gallons, 12 pack of gallons). We select the “check-mark” next to these values and click the “delete selected” button as shown in Figure 3.12:

image.png 975×415 82.4 KB

Finally, we fill the remaining fields in the table as we did in the previous examples. Figure 3.13:

image.png 975×475 99.6 KB

For our first example we will simply create the 1-Gallon and 4-Gallons variations of the product TallyTony’s Unparalleled Floor Cleaner. This means one parent with two children. The Basic info section of our file upload will look like this, Figure 4.5:

The 4th row is being used for the parent, the 5th and 6th are being used for the children.

In the row of the “Parent” we will not fill the Product ID, Product ID type, or Unit Count fields. We will fill cell B4, Seller SKU, which is the value that was “explained” in bullet point “a)” of Figure 4.2. The value of SKU of the parent, indicated in cell B4 will be referenced later when we create the variations. We will also fill the ProductName, Itemtype, Unitcounttype, and confirm that the product does not expire.

We will fill all the values in the rows of the “Children”. We will also fill the image URL, quantity, and Standard Price values.

Now, to create the variations, we will fill the Variation section so that it looks like Figure 4.6:

image.png 974×549 204 KB

Column “V” has the option of a drop-down menu that reads either “variation” or “package contains”. Let’s not worry about “package contains”. For the purpose of this thread we will only choose “variation”. We select this value only for the children. The Parent’s value is left empty.

Columns “W”, “Z” and “AA” can be ignored. They are related to the “package contains” value that we will not explain on this thread.

Column “X” is a drop-down menu that gives us all the possible variation-themes. For this example, we will work with “Itempackagequantity”. We select this value for both parent and children.

Column “Y” is the final piece of the puzzle referenced in bullet point “b)” of Figure 4.2. The cell Y4, “Parent SKU” will be left empty, as the parent does not need to relate to itself. All the children (in this case Y5 and Y6) will indicate the Parent SKU value that we inputted on cell B4. In this example that value is TTUFCGA.

Column “AB” has a drop-down menu with two options: parent and child. The cell AB4 will be the “Parent”, and AB5 and AB6 will be “Child”.

At this point the variation is indicated, but it isn’t complete. We have indicated what type of Variation we are doing, but we haven’t assigned the value of “Package Quantity” in any given column. We need to scan the remaining columns of the template to see where to input the “Package Quantity”.

If we scroll to the “Offer” section, column “ET” provides the value. Cell ET4, the one for the parent product will be left empty. Cell ET5 will indicate 1 (1 gallon), and cell ET6 will indicate 4 (4 gallons), as shown in Figure 4.7:

Please revisit the Second Section of this thread to see how to fill the remaining parts of the template.

Just as we did in the Third Section of the thread, we are going to offer the product in both Quarts and Gallons. The Basic Information section of the template will look as shown in Figure 4.8:

image.png 973×490 157 KB

Small changes from Figure 4.5. I have updated all the SKUs to correspond to the products (including the parent) and of course Product ID, name, and standard price.

For the variations we will do something very similar to what we did in Figure 4.6, but this time we will choose “Size” as the variation theme, and we will also have to update the Parent SKU value on column “Y”. Figure 4.8:

And now we need to find the column where we will indicate “Size”. This is column BC on the “Discovery” section, and we will input the values of “Quart” and “Gallon”. We could have also used numbers, for instance 32 and 128 (the respective OZ for quarts and gallons). Please note that this section contains other attributes that are important to variations like “Color” or “Scent Name”. Figure 4.9 shows how the section will look:

For a slightly more complicated variation, we will create the relationship of both size and quantity.

We will offer Quarts as singles, 6-pack and 12-pack, and the Gallons as singles and 4-packs.

We fill the Basic Information section as shown in Figure 4.10:

And the Variation section as shown in Figure 4.11:

image.png 974×497 198 KB

We will assign the sizes in the “Discovery” sections as shown in Figure 4.12:

And the Package Quantity in the “Offer” section as shown in Figure 4.13:

And with that our variations are done!