Products say they are imported but they don't show up in the list

Technical Q&A
1

I have imported a CSV with the titles filled out. However, once I get the success message and reload the list there still are no products showing up. I have included a copy of the csv.

Thank you!

2

Hey, @jrgleason ! Welcome to Shopify Community!

Thanks for sharing your product CSV file. I had a look at it and right off the bat, I found errors that would result in an issue with importing it. While it seems that the import was successful, if the products don’t appear in your admin’s product list it means the import was unsuccessful. You can find details about the unsuccessful import attempt in the email you received after importing.

In order for your store to be able to read your product CSV file, certain columns need to be filled in. The columns that require values are empty in your file, so we need to enter data in them. These columns are the following:

  • Handle
    • The handle is created based on your product title. For example, if the product has a title Black and White Shirt the handle should be black-and-white-shirt. Hyphens need to be present between the words as the handle is used in the product page URL (e.g. [https://myshop.com/products/black-and-white-shirt](https://myshop.com/products/black-and-white-shirt)).
  • Option1 Name
    • If your product has options, such as size or color for example, it should be entered here. If the product doesn’t have options or variants, the value should be Title.
  • Variant grams
    • This is the weight of the product in grams. If you don’t wish to add the weight, a 0 value must be added.
  • The following columns also require data however they are already present in your CSV file:
    • Title
    • Variant Inventory Policy
    • Variant Fulfillment Service
    • Variant Price

The columns outside of the ones listed above don’t require to be filled as they default to a specific value when left blank and they can be configured once they’re imported to your admin.

You can enter data underneath each column as per the instructions detailed above, and you can refer to this page for guidance on how to fill in the other columns if you wish to do so. Additionally, you can try adding a product to your admin and enter all the necessary information. Then you can export this product to a CSV file to see how the information should be formatted in the file.

If you have any questions about anything I’ve discussed, don’t hesitate to respond and I’ll help you out further. Alternatively, I understand CSV files are quite finicky and can be tricky to configure, so you’re welcome to speak with our support team for live assistance via chat or callback by visiting https://bit.ly/3cJkx8V.