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

[feroztasnova]

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? 

[Summer · Accepted solution]

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:
   • The current page of products
   • All products
   • Products you have selected
   • Products that match your search and filters
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!

[Kate_Bale]

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