Power Edit Prices by Percentage

General ShopSite user discussion

Power Edit Prices by Percentage

Postby nolanm5150 » Tue Nov 10, 2009 4:22 pm

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!!
nolanm5150
 
Posts: 1
Joined: Tue Nov 10, 2009 4:14 pm
Location: Oakland, CA

Use Excel and upload the database

Postby mjbrunelle » Mon Nov 16, 2009 9:57 am

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
mjbrunelle
 
Posts: 147
Joined: Sun Jun 21, 2009 5:09 am


Return to User Forum

Who is online

Users browsing this forum: Bing [Bot] and 95 guests