Project Home
Manuals
Contact Us
Download
Demo
Welcome,
Guest
. Please
login
or
register
.
Did you miss your
activation email
?
1 Hour
1 Day
1 Week
1 Month
Forever
Login with username, password and session length
News:
AbanteCart v
1.4.0
is released.
Home
Help
Search
Calendar
Login
Register
AbanteCart Community
»
AbanteCart Development
»
General Discussion
»
Mass Product Price Update by %
« previous
next »
Print
Pages: [
1
]
Author
Topic: Mass Product Price Update by % (Read 9451 times)
kiwi
Newbie
Posts: 38
Karma: +3/-0
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
Logged
"The more you know, The more you know you don't know"
Basara
Administrator
Hero Member
Posts: 5964
Karma: +284/-2
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
Logged
Please
rate your AbanteCart experience
or
leave your review
kiwi
Newbie
Posts: 38
Karma: +3/-0
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
Logged
"The more you know, The more you know you don't know"
Basara
Administrator
Hero Member
Posts: 5964
Karma: +284/-2
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
Logged
Please
rate your AbanteCart experience
or
leave your review
Print
Pages: [
1
]
« previous
next »
AbanteCart Community
»
AbanteCart Development
»
General Discussion
»
Mass Product Price Update by %
Powered by SMFPacks Social Login Mod