Skip to main content
M
Mark Armistead
April 4, 2022
Solved

Batch Change Stock Purchase or Sale Prices?

  • April 4, 2022
  • 1 reply
  • 0 views

I probably know the answer to this already, but if and when I need to adjust either the sale of purchase prices for my stocked or sale items. How do you change the several hundred stock items without spending hours doing one at a time?

 

And please DO NOT REPLY WITH THE COPY AND PASTE REPLY ABOUT SENDING IN FEEDBACK!!!!

Best answer by Giovann_G

Let me share additional information about importing data, Mark.

 

When importing adjusted stock for Product & Services in QuickBooks, you'll have the option to override the identical names or combined originals with the new additions. Ensure to select the Overwrite all values for each product or service that you import with the identical name box if you want to overwrite your stock.

 

Here's how:

 

  1. Click the Gear or Cogwheel icon.
  2. Select Import Data.
  3. Choose the Products and Services, then Browse.
  4. Locate the file containing your updated items.
  5. Follow the on-screen instructions to map and upload your data.
  6. Ensure that the Overwrite all values for each product or service that you import with the identical name is selected.
  7. Once done, hit Import.

 

For future reference, I've included this article if you want to learn how to adjust item quantity manually in QuickBooks Online: Adjust stock quantity on hand in QuickBooks Online.

 

You're always welcome to reply if you have further questions about importing data. We're always here to help you.

1 reply

S
ShiellaGraceA
April 4, 2022

Thanks for reaching out to us, @Mark Armistead.

 

I have some information about editing sales prices in batches. While this option isn't available in QuickBooks, you'll want to export your product and services list, update the sales price, and then import them to QuickBooks. This way, you won't have to edit each item.

 

Here's how:

 

  1. Go to Gear.
  2. Choose Products and Services.
  3. Select the Export icon beside the Printer icon.
  4. Click Export to Excel.

 

 

 

With the above steps, you're now able to update the prices. Once done, import the items by going to Gear, Products and Services, New, and then selecting Import.

 

 

 

Learn more about exporting and importing in these articles below:

 

 

Additionally, here's a guide that'll help you manage QuickBooks-related tasks. It contains our general topics with articles. Just choose the title that'll fit your concern: View all help articles for QuickBooks Online.

 

Please know that you're always welcome to reply to this thread if you have other questions about sales items. I'll be happy to answer them for you. Take care and have a wonderful day ahead.

M
Mark ArmisteadAuthor
April 5, 2022

Thank you for the reply Shiella. That does indeed sound like a reasonable solution, although doing other bulk tasks an not this seems to be a bizarre decision.

 

Could you please confirm that re uploading the adjusted stock list will overwrite the stock list on the server? I’m concerned, and have read on another post on these forums that it will add and duplicate to the stock list and not replace?

 

 

G
Giovann_GAnswer
April 5, 2022

Let me share additional information about importing data, Mark.

 

When importing adjusted stock for Product & Services in QuickBooks, you'll have the option to override the identical names or combined originals with the new additions. Ensure to select the Overwrite all values for each product or service that you import with the identical name box if you want to overwrite your stock.

 

Here's how:

 

  1. Click the Gear or Cogwheel icon.
  2. Select Import Data.
  3. Choose the Products and Services, then Browse.
  4. Locate the file containing your updated items.
  5. Follow the on-screen instructions to map and upload your data.
  6. Ensure that the Overwrite all values for each product or service that you import with the identical name is selected.
  7. Once done, hit Import.

 

For future reference, I've included this article if you want to learn how to adjust item quantity manually in QuickBooks Online: Adjust stock quantity on hand in QuickBooks Online.

 

You're always welcome to reply if you have further questions about importing data. We're always here to help you.

Terms & ConditionsAccessibility statement