Easy Populate 1.2.5.4 support

[Scrat]

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

[w2e]

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.

[Scrat]

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 ?

[w2e]

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

[Scrat]

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...

[kitcorsa]

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.

[kelvyn]

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.

For example, in the UK VAT is 17.5%, so you make a new column in Excel (or OpenOffice calc) and in B2 you put =A1*1.1.75 (assuming your prices are in column A) and copy down the column.

If you want to copy back the VAT-inclusive prices, just select them all, then paste-special, and you want just values (otherwise you'll have a circular reference)

[kitcorsa]

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

[Scrat]

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.

[kitcorsa]

For example, in the UK VAT is 17.5%, so you make a new column in Excel (or OpenOffice calc) and in B2 you put =A1*1.1.75 (assuming your prices are in column A) and copy down the column.

If you want to copy back the VAT-inclusive prices, just select them all, then paste-special, and you want just values (otherwise you'll have a circular reference)

Thats alot of work to do and very complex for some with limited computer skils.... im trying to give work away to other members of staff and releve my time to do more important things.

I need it so my member of staff (prob a temp) can be given a CSV file which has the product model number, name, prices (inc vat) and qty and all they have to do is copy over the prices given to use via our suppliers (in an excell file) or go through them and change the price to suit (when we get prices changes emailed to us as text files ie product AA bats was £1.99 now £1.55 inc vat)

this VAT export would be great as well if it got the vat price from the default VAT code on the site as you all know the UK vat is going to change again soon.