cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Level 2

Good morning, does anyone know a way to do a bulk inventory cost update?

 
Solved
Best answer 02-28-2020

Best Answers
Highlighted
Level 10

Good morning, does anyone know a way to do a bulk inventory cost update?

@wgrieves 

 

Unfortunately, there is no batch action to update the Cost field (or Sales Price field) at this time.

You will need to upload the CSV file to the Products and Services list page. 

(Gear icon > Lists > Products and Services > Select Import from the drop-down arrow next to New button).

 

import-list.png

View solution in original post

Highlighted
Level 10

Good morning, does anyone know a way to do a bulk inventory cost update?

@wgrieves 

 

"Can I download my existing inventory csv, make changes and then upload the updated file to overwrite"

 

That's how you normally do it. You can click Export to Excel link from the same Products and Services page.

 

"will that mess up all my inventory, cost of goods, ect?"

 

Always a risk, you need to be extra careful, with some expertise would be helpful. Suggest importing a few items first and see how it works.

 

 

View solution in original post

3 Comments
Highlighted
Level 10

Good morning, does anyone know a way to do a bulk inventory cost update?

@wgrieves 

 

Unfortunately, there is no batch action to update the Cost field (or Sales Price field) at this time.

You will need to upload the CSV file to the Products and Services list page. 

(Gear icon > Lists > Products and Services > Select Import from the drop-down arrow next to New button).

 

import-list.png

View solution in original post

Highlighted
Level 2

Good morning, does anyone know a way to do a bulk inventory cost update?

Can I download my existing inventory csv, make changes and then upload the updated file to overwrite or will that mess up all my inventory, cost of goods, ect?

Highlighted
Level 10

Good morning, does anyone know a way to do a bulk inventory cost update?

@wgrieves 

 

"Can I download my existing inventory csv, make changes and then upload the updated file to overwrite"

 

That's how you normally do it. You can click Export to Excel link from the same Products and Services page.

 

"will that mess up all my inventory, cost of goods, ect?"

 

Always a risk, you need to be extra careful, with some expertise would be helpful. Suggest importing a few items first and see how it works.

 

 

View solution in original post

Need to get in touch?

Contact us