Easy populate

[martinstan]

Hi

I've spent hours trying to figure this out so have turned to the forum for some help. Basically I've installed Easy Populate and it looks great, however I have a problem in that rather than updating product information that I'm adding to the Excel document, it's creating a duplicate product. The duplicate does have the correct new data but it means I'll have to go through and manually delete all the original products from within the admin area, which kind of defeats the object.

 

I would really appreciate some help. I've looked through the manual, and many posts on Easy populate but with no luck.

Many Thanks

[martinstan]

Hi

I think I've discovered something which could explain things but could someone confirm this for me. Does each product need to have a Product Model? If so can anyone suggest a work around as there are over 500 products already uploaded none of which have a product model.

 

Many thanks

Martin

[jonquil]

REQUIREMENTS

-------------------------------------------------

 

EasyPopulate requires the use of the product_model field (model number).

It won't work without the model number. The model numbers you assign

must be unique, i.e. you can't give all your products a product_model of "test".

 

The model number is the only unique bit of information that distinguishes all your products. If you take the time now to assign a model number to all your products, you will save yourself much aggravation.

 

Adding a model number is not a big problem. Can be done in your excel file as a Fill Down series.

 

jon

[martinstan]

Hi Jon

Thanks for your reply.

I have to be honest it's been a long day and I'll hold my hands up and admit I missed the relevance of this requirement in the Manual, so sorry for that. Brand new to the easy populate contribution. How can I avoid creating Duplicates or how can I quickly remove them if I do?

Many Thanks

Martin

[jonquil]

An easyPopulate upload compares what's in your excel file to what's in the data base. If it doesn't see a model number, it thinks you're adding a new product.

 

In excel, in the first row of whatever column your model_number is, key in a model number, e.g., 1099.

 

Click in that cell, and holding your shift key, press the down arrow (or page down) until you are in the last product's cell in this column.

 

Edit >> Fill >> Series

 

Series in: Columns

Type: Linear

Step Value: 1

 

Okay.

 

jon

[martinstan]

Hi Jon

Thanks again, but will that not add all those products(with a model_number) plus leave all the products (without a model_number) in my store?

Martin

[jonquil]

Yup.

 

I'm sorry, I thought it was obvious that you could delete the products you have in-store with no model number via phpMyAdmin.

 

Is this store live?

[martinstan]

Sorry Jon. No I don't know how to do that at present. It's not 'live' but is in a test area. Everything is backed up (including the database). I'm happy to get brutal with it if necessary.

 

Martin

[jonquil]

Somewhere in your hosting control panel, you have access to your database. Go explore :)

[martinstan]

OK thanks. :)

[martinstan]

Hi

I Found this. Will it have the desired effect:

If you need to reset a database to empty (no products but keeping the configuration settings), then take the following and paste it into a PHPMyAdmin sql window and you should be good to go. 


DELETE FROM `address_book`; 

DELETE FROM `banners`; 

DELETE FROM `banners_history`; 

DELETE FROM `categories`; 

DELETE FROM `categories_description`; 

DELETE FROM `counter`; 

DELETE FROM `customers`; 

DELETE FROM `customers_basket`; 

DELETE FROM `customers_info`; 

DELETE FROM `manufacturers`; 

DELETE FROM `manufacturers_info`; 

DELETE FROM `orders`; 

DELETE FROM `orders_products`; 

DELETE FROM `orders_status_history`; 

DELETE FROM `orders_total`; 

DELETE FROM `products`; 

DELETE FROM `products_attributes`; 

DELETE FROM `products_attributes_download`; 

DELETE FROM `products_description`; 

DELETE FROM `products_notifications`; 

DELETE FROM `products_options`; 

DELETE FROM `products_options_values`; 

DELETE FROM `products_options_values_to_products_options`; 

DELETE FROM `products_to_categories`; 

DELETE FROM `reviews`; 

DELETE FROM `reviews_description`; 

DELETE FROM `sessions`; 

DELETE FROM `specials`; 

DELETE FROM `whos_online`; 



ALTER TABLE banners AUTO_INCREMENT = 1; 

ALTER TABLE banners_history AUTO_INCREMENT = 1; 

ALTER TABLE categories AUTO_INCREMENT = 1; 

ALTER TABLE customers AUTO_INCREMENT = 1; 

ALTER TABLE customers_basket AUTO_INCREMENT = 1; 

ALTER TABLE customers_basket_attributes AUTO_INCREMENT = 1; 

ALTER TABLE manufacturers AUTO_INCREMENT = 1; 

ALTER TABLE manufacturers_info AUTO_INCREMENT = 1; 

ALTER TABLE orders AUTO_INCREMENT = 1; 

ALTER TABLE orders_products AUTO_INCREMENT = 1; 

ALTER TABLE orders_status_history AUTO_INCREMENT = 1; 

ALTER TABLE orders_total AUTO_INCREMENT = 1; 

ALTER TABLE products AUTO_INCREMENT = 1; 

ALTER TABLE products_attributes AUTO_INCREMENT = 1; 

ALTER TABLE products_description AUTO_INCREMENT = 1; 

ALTER TABLE products_options_values_to_products_options AUTO_INCREMENT = 1; 

ALTER TABLE reviews AUTO_INCREMENT = 1; 

ALTER TABLE specials AUTO_INCREMENT = 1;

 

Thanks

Martin

[jonquil]

What you've found is how to empty a data base completely, except the configuration tables. Your goal is to clear out all the products.

 

Select all the table that begin with "products" and EMPTY them.

 

jon

[martinstan]

ok thanks Jon. I'll give it a whirl

Martin