Articles ·
Fix an Invalid Availability Value in Google Shopping
The four accepted availability values, the wrong spellings to look for, and a safe way to correct a whole column in your Google Shopping feed.
Have this error in your own feed? Preview the fix free with Rejected Feed Repair.
An invalid availability value means the cell holds something other than one of four accepted values: in_stock, out_of_stock, preorder or backorder. Write each one in lowercase English with underscores, and submit one value per product. To fix a feed, list every different value in the availability column, map each to the right one of the four, replace them, and check the column again.
The availability values Google accepts
The attribute is called availability and it is required for all products. These are the supported values and what each one means:
- in_stock: you are accepting orders and can fulfill the purchase request.
- out_of_stock: you aren't accepting orders, or the product isn't available for purchase.
- preorder: you are accepting orders, but the product has not been released. Use it only for new products. It needs an availability_date.
- backorder: the product isn't available now, but you are accepting orders and it will ship when available. Use it for existing out-of-stock products you take orders for. It also needs an availability_date.
The values must be in English, whatever your target country, feed language or account language. In a text feed the cell simply reads in_stock. In an XML feed the same value goes inside the g:availability element. You will see build_to_order on Google's availability page, but it is listed for vehicle ads only. It is not in the general list of supported values.
Wrong spellings to look for in your column
Google's pages do not publish a list of bad spellings. They also do not say whether capital letters or stray spaces are tolerated. The only documented form is lowercase with underscores, so match it exactly. These are the patterns I check for, because none of them is on the accepted list:
- In stock, with a space, or instock with no separator.
- In Stock, IN_STOCK or any other capital letters.
- out-of-stock with dashes, out of stock with spaces, or outofstock.
- sold out, unavailable or discontinued.
- available, yes, no, true, false, 1 or 0.
- pre-order, pre order, back order or back-ordered.
- Empty cells.
- Values with a space before or after them. These look correct on screen but are not an exact match.
If you copy values from your page markup, note that Schema.org words are different from feed values. Google maps InStock, LimitedAvailability and OnlineOnly to in_stock. It maps Discontinued, InStoreOnly, OutOfStock and SoldOut to out_of_stock. PreOrder and PreSale map to preorder, and BackOrder maps to backorder. Do not paste the Schema.org words into the feed.
How to correct a whole column safely
Google's pages I read do not describe a bulk-fix method. This is ordinary spreadsheet practice, not a Google procedure. The aim is to change only the availability column and nothing else.
- Save an untouched copy of the feed file before you change anything.
- Trim leading and trailing spaces in the availability column.
- List the unique values in that column with a filter or a pivot table. Write down every one you see.
- Make a small table with two columns: the value you found, and the one accepted value it should become.
- Replace on whole-cell matches only. Replacing part of a cell can damage other values. Changing a fragment such as stock would hit both in stock and out of stock.
- List the unique values again. You should see only the accepted values, plus any blanks you still have to decide.
- Check that the row count matches the original and that no other column has changed.
- Save in the same format you started with, upload it, and read the Issue Details Page in Merchant Center to see what remains.
What only you can decide
A find-and-replace can fix spelling. It cannot tell you the real stock position. These calls belong to you:
- Whether a product marked available is actually in stock. Check your inventory, not the old word in the cell.
- Whether a blank cell is in_stock or out_of_stock. Do not fill blanks with a guess.
- Whether a product is a true preorder or a backorder. Preorder is for unreleased new products only.
- The availability_date for every preorder and backorder row. Use ISO 8601, for example 2016-02-24T11:07+0100, at most 25 characters and no more than one year ahead.
- What to do with products you no longer sell. Remove discontinued products from the data rather than marking them out_of_stock.
- How to hide a product that is still for sale. Do not use out_of_stock for that. Use excluded_destination, or pause, which covers up to 14 days.
Keep the value honest against your site. A mismatch between the landing page, structured data, checkout page and data source triggers a product disapproval, so the feed should say what your product page says.
When the column is only part of the problem
If availability is one of several errors in the same file, Rejected Feed Repair ($19) may fit. It compares your product CSV or TSV with your Google error export and corrects availability values to the accepted ones. It gives you back a corrected feed and a list of fields you must fill in yourself, such as dates. You see a free preview before you pay. It does not connect to your Google account, invent dates or stock status, or promise that Google will approve your listings.
A quick check before you upload
- Every availability cell is one of in_stock, out_of_stock, preorder or backorder.
- Every preorder and backorder row has a valid availability_date.
- No cell has capital letters, dashes, spaces or hidden spaces in it.
- Each product has exactly one availability value.
- The value matches what the product page shows.
Where this comes from
Feed First Aid is not affiliated with Google. Google’s rules change, so check the pages above for the current version.