Easy Populate 1.2.5.4 support

kevinme EPA is a commercial product, I would suggest contacting the supplier. I have read there is not any activity on support, I do not know what warranties/support EPA comes with look into it.

Scrat thanks for responding

This file has 4500+ products where there are only 3600+ actual products.

I don't know of a way to exclude the linked items other than by excluding a category from EP and that wouldn't work because there are items in those cats that do need to be included.

buildingblocks Have a look at this file.

Please note this has no guarantees or warranties only use on a test site until you are totally happy it works as I HAVE NOT TESTED IT :no:
New Complete Download file without categories and no duplicates. Complete - No Categories
Very Important Note
If you upload a new product in this format it will not have a category, so you would need to set a category manually. As I have not tested it it may have other issues so TEST, TEST, TEST

File Location : admin/easypopulate.php

Scrat:

buildingblocks Have a look at this file.

Please note this has no guarantees or warranties only use on a test site until you are totally happy it works as I HAVE NOT TESTED IT :no:
New Complete Download file without categories and no duplicates. Complete - No Categories
Very Important Note
If you upload a new product in this format it will not have a category, so you would need to set a category manually. As I have not tested it it may have other issues so TEST, TEST, TEST

File Location : admin/easypopulate.php

Thanks. I'll check it out.

On another note the descriptions in a working store contain simple html <br> tags. We exported these items to EP and we are encountering a problem that when importing this easy populate file into another store, the descriptions end up getting extra <br> tags inserted

When I look at the descriptions in open office calc they look just like this

<b>Title:</b>
<br>
Magazine Ad For Sunkist oranges
<br><br>
Measures: 10x10
<br><br>
<b>More Information</b>
<br>
Womans Day Sunkist Lemons Ad June 1962 issue.
<br><br>
<b>Condition</b>
<br>
Vintage ad with some fade, light edge wear with torn edges on one side.

and when importing into zen cart this way, extra <br> tags are being added making large gaps between lines so the descriptons don't look nice.

But if I manually edit the descriptions and merge the lines like this:

<b>Title:</b><br>Magazine Ad For Sunkist oranges<br><br>Measures: 10x10<br><br><b>More Information</b><br>Womans Day Sunkist Lemons Ad June 1962 issue. <br><br><b>Condition</b><br>Vintage ad with some fade, light edge wear with torn edges on one side.

and then import the file to zen cart, the description displays as it should. No extra <br> tags get added.

Any ideas how to get around this problem without having to manually edit each and every description?

buildingblocks By the looks of it you may have carriage returns '\n' and line breaks '<br>' in the descriptions. So when you import depending on the browser you will see two lines instead of one.

thanks again scrat. The \n was it.

Just thought I'd poke my head in and say hi. I've logged in for the first time in like 9months and had a number of PM's. I only had one client who used ZenCart, and I moved them over to the now defunct Chromium Cart which merged back into Open-Cart, which is nice and free too.

After the joke that was version ZenCart v2.0 I got sick of it.

I now work a lot on CS-Cart, which is really fabulous. It has a couple issues here and there, but it's 300% better than ZenCart, but not free.

So I don't really have any use to work on EP 1.2.5.5CSV anymore.

But to all you who still use ZenCart, you have my sympathy and condolences.

Thanks,
Adam

Hi -
Am using EP 1.2.5.4 which works just great.
However, I am trying to do a model no./attributes download, but every time I try the system crashes and I get a message
"[an error occurred while processing this directive] ".
Any suggestions as to what I can do?
Thanx in advance
Rufus

rufusclc If you have not changed any code I would suggest it is a server issue, whether Mysql or PHP.
Have you tried a download to /temp folder on the server ?

If you haven't changed any code and you are using Langer 1.2.5.4 version, I would have a word with your server support, as Mysql or PHP may need a restart.

Hi,

I got a "product debris" warning message from EP which suggested using phpmyAdmin to remove the debris.

however, i cannot find the product_id in phpmyAdmin.

in the store export file, i see 2 product_id's for 1 product_model. When i search in phpmyAdmin by product_model, it only shows 1.

How do i find that debris?

w2e This is a 'known' bug in V1.2.5.4 if you search this thread you will find out how to remove the warning

it's not a bug though.

my store export files do show 2 id with the same products...?

w2e Sorry I am a little confused...

1. my store export files do show 2 id with the same products...?

2. "product debris"

are to separate issues,

1. Give a example of your .csv, have you got this product in two catorgies ? If you have this is normal as if you look at the cat. that those product id's are in will be different.

2. 'Yellow bar'

x.Number; partially deleted product(s) found! Delete this dross to prevent unwanted zencart behaviour by clicking here.
You are seeing this because there are references in tables to a product that no longer exists, which is usually caused by an incomplete product deletion. This can cause Zen Cart to misbehave in certain circumstances. at the top of EP main page is a known bug in this version

Actually, only 1 product/item/category is supposed to correspond to this one product_model. I saw the "debris" warning a day ago and thought that the problem is because of the "debris."

The problem is my store (using the side-box "search" on my site) shows a product/item count of say 2000, while there are actually only 1000 items. The store export file shows 2000, with 1000 duplicates whose only differences are the product_ID's. These duplicate items' product_id's cannot be found in phpMyAdmin.

So how can I delete these duplicates?

Thanks for any help.

w2e The 'products_model' is unique to each product, thus you can only have 'one' product in the 'products' table with that 'products_model' ref. But you can have that same unique 'products_model' in all your categories, so if you have four categories you would have four products not one. If you look in your 'products' table you should see that you will have only one product, if you then look in the 'products_to_categories' table you will see the products_id to the categories_id.
I think you are getting a little confused around 'products_model' to 'products_id' as these are two entirely two different things.
I would suggest give us an example of your .csv export file and we can see what you are looking at, this would then be very clear to see what your problem is ?

These are the 2 duplicate items in my store export file:

v_products_id v_products_model v_products_type v_products_image v_products_name_en v_products_description_en v_products_url_en v_specials_price v_specials_date_available v_specials_expires_date v_products_price v_products_weight v_products_date_available v_products_date_added v_products_quantity v_manufacturers_name ptc_categories_index_path ptc_categories_destination_path ptc_categories_linked_path v_tax_class_title v_products_status EOREOR
1288246 IIS-BO2010A Product - General IIS/BO2010A-H0.jpg Muay Thai Boran Book - de Cesaris Muay Thai Boran by Arjan Marco de Cesaris. The martial art of Thailand. Endorsed by AITMA. History, techniques, training, interviews, and more. 207 pages. 7 in by 9.5 in. ISBN #9781897307502. 24.95 2 0000-00-00 00:00:00 06/28/10 02:00 AM 10 Martial Arts/Self Defense IIS 1 EOREOR
1294929 IIS-BO2010A Product - General IIS/BO2010A-H0.jpg Muay Thai Boran Book - de Cesaris Muay Thai Boran by Arjan Marco de Cesaris. The martial art of Thailand. Endorsed by AITMA. History, techniques, training, interviews, and more. 207 pages. 7 in by 9.5 in. ISBN #9781897307502. 24.95 2 0000-00-00 00:00:00 07/02/10 04:51 AM 10 Martial Arts/Self Defense IIS 1 EOREOR

w2e By the looks of it you are using EPA or a other version of EP (than 1.2.5.4).
From what I am seeing you have two entries in the database :

products_id => 1288246
products_id => 1294929

It looks as if the version you are using uses the v_products_id as the key not the products_model. Are you sure you have not got both these entries in the database ?

What version are you using ? (Always a good idea to specify as this save you time)

As you will see from the thread there are several version available of EP, the most reliable one is 1.2.5.4 all others have bugs...

is there a way that when i download my CSV file from easy populate that the prices in the price colum is the price INC VAT.

this would save me hours and hours of working out prices without vat on my calculator.

going to ask again but explain more as requested,

is there a way to add a new download to easy populate?? my product numbers are just numbers ie 1234, i would like a download for product number/product name/price only simulate to what you get as standard but with product name as well

when i click on admin>tools>EP and the download the **Download Model/Price/Qty .csv file to edit **button what i get is the model/price and the qty which would be great but my products dont have modelnumbers relevant to the item ie my iteams are just numbered (ie 12345), is there a way to add to this csv download so it would download the model/item name/price/qty so i know what item im chanign the price on. Downloading the complete file is just over kill and a nightmare working through just to update prices and stock

kitcorsa Yes anything is possible, but the difficulty is that ZC works its prices out from the 'net' amount applying the Tax appropriately, it would mean coding in EP to do this which would be a little in depth. I would go down the OO or excel route personally if you don't know php very well or seek a custom coder.