Denver Research
General Category => ezPower => Topic started by: drivethru on March 20, 2017, 01:49:08 AM
-
I was wondering why (for me) there is 3 pages of products in the list all? Why are they not on one page for a person to export and save? The save inventory feature ProductsX doesn't make any sense when exported to Excell. I use this feature when checking inventory to see if have duplicates or wrong prices. Plus I can alphabetize it which nobody can do in the products page. That is one feature that I think a lot of people would like to see.
-
Like I mentioned in my other post, I use the "Import Products (older version)" to bring items into EZP. Along with that, I use "Export List" to export items from EZP - it creates a .txt file that I can then open it with Excel. It results in a single page that can be manipulated the same way as anything else in Excel.
I'm not necessarily recommending it for you (as Ronald mentioned, you can really mess up your Product list in EZP if you import from Excel and don't do it right), but it works well for me.
As a precaution, I always try to make sure to import a file in my back office version of EZP first (before importing it to the "live" version) to see if it messes up anything. As an example, if you're just one character off on something like a Category, you'll suddenly find a new Category in addition to the old one. Or you can suddenly double your inventory.
-
OK I went to products- list ALL -exported to file- and page 2 and page 3 were missing in excel. So when I export the list I have to go More products and export those items and then again for the 3rd page. That was my question as to WHY are not all the product on ONE page so I can export 1 page and convert it in Excell instead of 3 pages in order to get my FULL inventory
-
It's a physical limitation that is inherit in the Windows List Control.
-
Ronald, does it possibly have to do with the way the .txt file is opened in Excel? Mine has always appeared with the full list when it opens in Excel - never just a single page of products.
-
Was wondering what Ver. you are using? If you import files into the back office one in Ver.14 it goes right to the Main POS. Was also wondering how many products you have?
-
I'm on v14, and have about 1,000 products in EZP. I keep my back office version disconnected from the rest of the network so I can do some testing without affecting the "live" version. And if I want to bring it up to date, I can copy & paste the files from the EZP folder on the "live" computer.
-
WOW I just found out I can alphabetize the products. This is GREAT!!!!!!!!!!!!
-
Can you alphabetize them within the program, in Product Control? How?
-
Yes, under Tools in the Product Control.
-
The limit is 1000
The alphabetize is by Item#