Easy Populate 1.2.5.4 support

Hello GabbyTwin,

Quote:

---

Originally Posted by gabbytwin

Hi,
hope someone can help me with an easy way of listing the product at their NETT price with any taxes included.
I have a lot of products to go and edit prices with if I need to work out each one minus the taxes.
Any idea will be great , did a search and couldnt find anything :(

---

I am not sure I know what you are asking. In Zen Cart you can turn on the displaying of the price with tax for the customer, administer, one or the other, both or neither.

Most people suggest opening the download from EP in a spreadsheet as it may be quicker than even a flat database (i.e., SQLite). This would make it easy to add your own column, for your own use, such as price_with_tax, and just have it calculated for you (price*tax rate).

If you think everything is being downloaded with the tax already added, and you want to remove it, then the new column would be something like price_without_tax, and you have to figure out how much to discount something to get the price before tax. The price before tax is a little more tricky as you can't just use the tax rate. An example is if I sell something for 100 units (dollars, lair, euros, yens, etc), and tax is 10%, the total is 110 units. If I just subtracted 10% from the final sale price I would be subtracting 11 units (10% of 110), leaving 99 units, a difference of 1%, or 1 unit, from the actual price before tax.

You could also alter EP's files to add a new field (column), and make sure you include the proper code in both the up-load and down-load sections. You would need to make sure you use the correct table and field in EP's database to do so, yet it most likely could be done.

Maybe AWEV can answer this one (Help)
I try to download the attributes and the file shows only one attribute, the same one, for all my products.
Example. If I have a shirt color blue and a choice of red, the attributes download shows all 1050 products as having only a red attribute and ignores the blue attribute.

Thanks

Hello Elkbow,
Sorry, I have not started playing with attributes yet in ZC, and have avoided them in EP up to this point. I know that will change in the near future, I am just worried about one headache at a time right now. Just from what you have said, and other posts in the last 10 or 15 pages, I will try offering a guess.

First, you may want to change your shirt to have no color, and add blue as an option. This would then show blue as an attribute. Make sure that you indicate that the customer MUST select an attribute - with blue being the default, or red as an option.

As to EP adding the attribute to all of your items, I think there is a problem with the logic it uses to retrive the info, and then output it. I am rather sure that you don't sell 1050 shirts of the same type with the same color options. How to fix it I don't know at this point, just rest assured that it doesn't goofe up to much with the actual database(ZC), and that seems to remain correct. This is where I am NOT knowldegable about the things.

To summersize, set the default color of the shirt to blank, add blue as an option, making it the default, and force people to select a color.

Hope this helps in some small way.

Awev
Thanks for the reply. I used that example of color to make it easy. Actually I think I have too many attributes. This is an Archery Shop and there are really a LOT of combinations available to the customer. So What I have now done, is list the products, then go into the attributes and configure them one at a time. If you really want to see how many-- and EP would really help here -- look at archeryshop.com/zencart.

Look up the product Arrows, or under Accessories/Inserts/aluminum Inserts and you will realize how important the EP Attribute function is to me. I was considering a download by MySql, correct the table, then upload, but I'll probable wack my DB.

I appreciate your answer, and when installed for another company, I will use your method at the start.

Elkbow

Hi Elkbow,
Make a backup of your database that is part of ZenCart, then download it to your computer. If you don't have MySQL set up yet go ahead and grab it, along with the GUI tools. You can use the Admin GUI tool to do a restore from the file you downloaded.

Don't worry about messing up your database, since you imported it as a restore operation you can do it again, if you break it the first (or fifth) time, and keep hacking away at it till you get it the way you like it. You can use the Browswer GUI tool to help examine everything, execute "SELECT" commands, run updates, etc.

Once everything is as you like it do a backup of your local copy, drop the ZC database, and a restore from your local backup (the edited, corrected version).

If you have never used MySQL before, or any type of SQL rdbm, then this will be a nice crash course in it. The browser GUI provides some nice, helpful, info in the lower right hand corner of the screen.

I keep getting this error upon checkout -
Please update your order ...
Product Name: Bariatric Mattress Only 48 W ... Quantity Units errors -
You ordered a total of: 1 Min: 0 Units: 0

I only get this error with the products I entered using epa.
The minimum, units and quantity all show up the same in the products manually entered as the products entered via epa.

I have tried to turn off any type of inventory control using the stock, listing and product type edits but nothing takes this error message off. The only way it disappeared was when I went into an item (first entered using epa) manually and changed the product quantity from 1 to 99999. I have over 8000 products that I entered using several different databases. I really don't want to go into the databases and change all the quantities again. I just want to disable any type of inventory control (which I thought I did). I don't have inventory issues.

One more epa related problem - I cannot add or change the quantity of products ordered on any of the items entered using epa. The manual products all have a quantity altering button available at the product description page and the checkout page but never for the epa loaded products.

Any ideas?

Dear Colleagues,

New Zenner here. I note that there are two EasyPop versions available on Download. One is Easypop Langer and the other is Easypop from OSC. Which one is the best, in your opinion. In the meantime, I shall endeavour to read all of the post's associated with EP and try to locate an easy to read and understand method of installing the mod into Zencart.

On another note, why has the issue of there being no way to import XML live feed into Zencart not been resolved yet? If it has been resolved, please post details. On this latter issue, I have read the following article;

http://www.sitepoint.com/article/php...arsing-rss-1-0

Thx.

freshstart.

Does the free download one work on the most recent version of zencart or do we have to purchase the mod for the $65 on langers site?

The version everyone should download is 1.2.5.4 last updated by langer, the other one is older and has many bugs.

Direct links to download EasyPopulate:
http://modhole.com/modhole/index.php...JAS_File_id=60

or

http://www.zen-cart.com/archived_con...p_v1.2.5.4.zip

There's really no need to read any of the post in this thread to be able to successfully install and use EasyPopulate, installation and usage instructions are included in the download.

The standard and free download works on the latest version of ZenCart. No need to purchase the advanced version unless you need more advanced features. I tried the advanced version once and I actually found it a bit more difficult to use so I just stuck to using the standard version.

Quote:

---

Originally Posted by treewoman

I keep getting this error upon checkout -
Please update your order ...
Product Name: Bariatric Mattress Only 48 W ... Quantity Units errors -
You ordered a total of: 1 Min: 0 Units: 0

I only get this error with the products I entered using epa.
The minimum, units and quantity all show up the same in the products manually entered as the products entered via epa.

I have tried to turn off any type of inventory control using the stock, listing and product type edits but nothing takes this error message off. The only way it disappeared was when I went into an item (first entered using epa) manually and changed the product quantity from 1 to 99999. I have over 8000 products that I entered using several different databases. I really don't want to go into the databases and change all the quantities again. I just want to disable any type of inventory control (which I thought I did). I don't have inventory issues.

One more epa related problem - I cannot add or change the quantity of products ordered on any of the items entered using epa. The manual products all have a quantity altering button available at the product description page and the checkout page but never for the epa loaded products.

Any ideas?

---

Does anyone have any ideas about this? I am really in need of help to get my site live.