I’ve been out of the game a while and it’s time to update my listings – and probably see them get removed for some weird penalty or bug – and was pondering whether to do the updates through File Upload or through the simple “Edit Listing” option.
File Upload still the better way or can I get away with the Edit Listing panel?
I’m going to be changing everything from titles to images to bullets.
I still use the Seller Central GUI for image uploads, but you can do it via flat file too. There is a field for the main image, and 8 other fields for alternate images. Some people host their images elsewhere like their website and just post the URL in the flat file, this is probably the best way as it’s easier and you always have a copy somewhere other than Amazon.
If you have existing listings I would start with downloading a CLR. If you’re starting from scratch you should probably download a blank sheet from your category.
You can run your update from the CLR, the category template, or even a delimited file.
I have been working on updates all week, and the new AI detected system actually has worked for every update I have made. Don’t forget to expand ALL the fields as there are some that are hidden by default. That has gotten me even though I knew about it ahead of time. You can get an error that you can’t figure out and it’s because you haven’t filled out a hidden field.
Hope this helps a bit. I’m still pretty much a n00b when it come to flat file uploads, but I have been doing a lot of it this week and it’s fresh in my mind. I also had some wonderful help from @Lost_My_Marbles and some other folks here on the forums. I don’t have thousands of listings so your experience may be a bit different than mine, but it’s not that hard once you get used to it, and you’ll never go back.
We have our images on our site and provide a link in the excel template file. Generally, we just put in the main image and then use the Image Manager through Seller Central to add and control each items additional images.
We would start with downloading a CLR. Then we would download a blank category (or categories) template. We would use the CLR to start the initial fill of the blank template. Once we have our base (blank) template filled out, we would reuse it for a few times. Since Amazon constantly changes things, we would repeat downloading the CLR and blank template about every 6 months (or at minimum … once a year) and proceed and repeat the process.
Typically, we upload the blank template file after we have renamed it (noting the date in the name) and saved a copy of it for future reference.
Both Update (full) and Partial Update work and have their good and bad points. Update removes all data of an item and then replaces the info from the file that you upload. If something is missing, then it is gone (which is the reason we also have copies of the last full upload). Partial Updates are good for quick updates but don’t always take and sometimes have to be repeated or even require a full update to get to go through. But for simple price changes or changing the individual handle time, the Partial will save you a lot of time (once you are use to working with the excel templates).
Start with one item on the excel template and see how it works. We wouldn’t do the best seller … pick a slow seller in case you make a mistake so you can redo if needed to correct an error.
If you have items in different categories, set up a template to work with each category.
If you have 1000s of items, break them into workable groups when creating their excel template.
Create a folder (with sub folders if needed) to keep all of the excel templates in.
Create a file naming system that makes it easy to know what it is and the date it was created.
We have them hosted on our Shopify storefront. I can easily export out a spreadsheet from Shopify with the product info, including the URLs for the images, that I just copy and paste into the spreadsheet.
I usually don’t update all of my listings at once, but if I were, that would probably be the route I took. I normally work on one variation group at a time, so I will just use the variation wizard to create a spreadsheet to work off of.
I typically do Partial Updates because I have a lot of FBM listings, and doing a full update would mean pulling inventory quantity data, and I try to save myself that step if I can.
Tip: If your listings are FBA, make sure the quantity field is blank because having anything there can cause it to switch to being FBM. I’ve had the QLR have data in that field before for FBA listings, and if you don’t catch it, it can cause problems.
“RAFN” is ‘Amazonese’ for “Remote Fulfillment Network”, and anything with “MX” in it typically refers to something associated with the Mexican Global Marketplace - may I ask if you are enrolled in the “Remote Fulfillment with FBA” (link) Program as indicated on the Remote Fulfillment Dashboard @ https: //sellercentral.amazon.com/rafn/inventory/home?
Amazon-fulfilled products: For those merchants using Amazon fulfillment services, this designates which fulfillment network will be used. Specifying a value other than ‘DEFAULT’ for fulfillment_center_id will cancel the Merchant-fulfilled offering. Resubmitting with a blank or ‘DEFAULT’ value for the fulfillment_center_id, along with quantity, will switch the item back to Merchant-fulfilled. Merchant-fulfilled products: Do not enter fulfillment_center_id, as it is not applicable.
If you have used Amazon_NA in the past as FBM, then it should be Amazon_NA or left blank. If you are doing a Partial Update, you can leave it blank. If you are doing a Full Update, you can leave it blank but must put in a quantitiy (on hand / available for sale) for the item.