Author Topic: Mass Product Price Update by %  (Read 6391 times)

Offline kiwi

  • Newbie
  • *
  • Posts: 38
  • Karma: +3/-0
    • View Profile
    • Kiwi Custom Stamps Ltd
Mass Product Price Update by %
« on: October 12, 2018, 05:56:54 PM »
Hello friends,
Can anyone help me?
my supplier has increased my buy price on products by 5%.
i would like to pass this on to my customers.
How can i update ALL product costs by 5% and increase all Product Sell Price by 5%?
******************************************************************
Please don't tell me i have to manually update each product one by one :-(
******************************************************************
i only have one main supplier so the 5% increase can be across ALL products.
if anyone has had to do this please advise how you did it.

Sam
"The more you know, The more you know you don't know"

Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 5753
  • Karma: +273/-2
    • View Profile
Re: Mass Product Price Update by %
« Reply #1 on: October 15, 2018, 02:17:02 AM »
It is easy to do in excel or any spreadsheet editor.
Backup, export your products into CSV format. Change price column in bulk with formula , and import to your store.
https://abantecart.atlassian.net/wiki/spaces/AD/pages/14975089/Import+Export

Offline kiwi

  • Newbie
  • *
  • Posts: 38
  • Karma: +3/-0
    • View Profile
    • Kiwi Custom Stamps Ltd
Re: Mass Product Price Update by %
« Reply #2 on: October 15, 2018, 03:48:24 AM »
Thanks Basara,
i dislike CSV files, to many Columns etc, wish there was an easier way? i guess ill have to wait till 2030 for that.
any way can you help , i got this error when trying to import the updated CSV file. Error 500
"The more you know, The more you know you don't know"

Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 5753
  • Karma: +273/-2
    • View Profile
Re: Mass Product Price Update by %
« Reply #3 on: October 15, 2018, 04:49:57 AM »
Looks like some issue on your server. Maybe permissions.
Do you have any errors in AbanteCart error log?

Good idea for new extension by the way. You can create it and sell on marketplace like others do:
http://marketplace.abantecart.com/group_change_category
http://marketplace.abantecart.com/bulk_specials_generator
http://marketplace.abantecart.com/developer-faq




 

Powered by SMFPacks Social Login Mod