Denver Research

General Category => ezPower => Topic started by: cosy on June 30, 2011, 07:51:38 AM

Title: discount by category
Post by: cosy on June 30, 2011, 07:51:38 AM

Is there a way of setting a discount for categories instead of going through each individual item which would take a long time to do as i have around 1100 items.

Title: Re: discount by category
Post by: ronaldrwl on June 30, 2011, 12:51:58 PM

If you are comfortable using Excel, export the products, add the discount%, and import them back in.

Title: Re: discount by category
Post by: Ches on June 30, 2011, 05:26:53 PM

Quote from: ronaldrwl on June 30, 2011, 12:51:58 PM

If you are comfortable using Excel, export the products, add the discount%, and import them back in.

Yep that's what I did and it works great!!

Title: Re: discount by category
Post by: rjsmeyer on January 10, 2012, 04:41:17 PM

I found this earlier thread about importing and exporting.  This is exactly what I want to do to add a few discount levels for all my items.

I'm comfortable with using Excel for it and all that.  What I wonder, though, is how it might affect quantities.

If I understand right, if I export the entire inventory list, the quantities listed in the program will not change, right?

When I'm done editing and want to import them, do I need to zero out all quantities before I import?  Would it effectively double my inventory counts if I don't? 

Thanks!

Bob

Title: Re: discount by category
Post by: ronaldrwl on January 12, 2012, 06:36:18 AM

Yes.  You'll want to zero the inventory quantities.