We want (need) to be able to select as many products as we want via the PowerEdit tool and make prices changes by percentage (both positive and negative percentages). With vendors changing prices on us on a regular on-going basis the feature is imperative.
It does not seem like a major request for this base-line type of functionality... you just need to do the math! THANKS!!
Power Edit Prices by Percentage
-
nolanm5150
- Posts: 1
- Joined: Tue Nov 10, 2009 4:14 pm
- Location: Oakland, CA
- Contact:
-
mjbrunelle
- Posts: 147
- Joined: Sun Jun 21, 2009 5:09 am
Use Excel and upload the database
Set up an Excel sheet to calculate your price however you want.
Have a second Excel sheet with SKU and PRICE headings saved as a Txt file.
After updating the Pricing copy the column and past into the txt file.
Use "Paste Special","Value" this way Excel pastes the value of the formula.
Save the txt formated Excel spreadsheet.
Do a PRODUCT database upload, for PRICE by SKU. Takes about 10 seconds.
MarkB
Have a second Excel sheet with SKU and PRICE headings saved as a Txt file.
After updating the Pricing copy the column and past into the txt file.
Use "Paste Special","Value" this way Excel pastes the value of the formula.
Save the txt formated Excel spreadsheet.
Do a PRODUCT database upload, for PRICE by SKU. Takes about 10 seconds.
MarkB