How can I include the price column in my Shopify product export?

Shopify Discussion

Topic summary

Including price in an inventory export isn’t supported. Prices can be updated via CSV, but only through a product CSV; inventory (qty) and prices must be managed and imported using separate files.

How to export a product CSV:

  • Admin > Products > Export
  • Choose products (current page, all, selected, or filtered)
  • Choose CSV type (spreadsheet-friendly or plain text)
  • Export, edit the price columns, then import via Products > Import

References to guides for product CSV structure and the import process were provided.

Latest development: A follow-up asks if a single download can include inventory plus prices at cost and RRP (recommended retail price). This remains unanswered, so it’s unclear if a combined export is possible.

Key terms:

  • CSV: Comma-separated values file used for spreadsheet editing.
  • RRP: Recommended retail price.

Status: No resolution for combining inventory and prices in one export; original need is addressed by using the product CSV for pricing and the inventory CSV for quantities separately.

Summarized with AI on December 19. AI used: gpt-5.
1

Hi i am newbie in shopify. I export my product inventory from my shop where i got only product qty column. I didn’t get price column. I want Price column also, so that I can update price with qty and import same file for update my store. Can I do this?

2

Hey, @feroztasnova ! Welcome to Shopify Community!

I’m glad to learn you’re making use of CSV files to manage your products. You can certainly update your product prices through a CSV file, however, you’ll need to do this on a product CSV, not an inventory CSV. This means you’ll need to update your inventory and prices through separate files, but don’t worry, as the product CSV is just as easy to work with as the inventory CSV.

To export a product CSV file, you can go through the following steps:

  1. From your Shopify admin, go to Products.
  2. Click Export.
  3. From the dialog box, choose the products you want to export:
  4. Select which type of CSV file you want to export:
    • CSV file for Excel, Numbers, or another spreadsheet program. Use this format if you plan to use a spreadsheet program to edit your product CSV file.
    • Plain CSV file. Use this format if you plan to use a plain-text editor with your product CSV file.
  5. Click Export products.

Once you have the file, you may then edit it accordingly. You can find a guide on the product CSV and its columns on this page. When you’re ready to import it, you can refer to this guide.

If you have questions about anything else, don’t hesitate to create a new post and we’ll help you out!

3

Hello - Is there a way to download both the inventory and the prices at cost and RRP in one download? I can only find, products with prices, or inventory without RRP and prices thanks