Easy Populate Updated Product Uploads

[priyaj1023]

Hi,

I have 15110 products on my site. I want to update all product names. I want to remove the special characters(&,.$# and other all) from the product name. I can get the list of products by using export tool. But If I edit all product names then how can I upload it. I was using the

Easy Populate 2.76i-MS2 = Upload and Import EP File - Update Only - Insert into db.

But I am getting below error message.
__________________________________________________ ___
File uploaded.
Temporary filename: /tmp/phpbC1vD2
User filename: UpdatedEP2010Mar02-0808_Final.csv
Size: 19992109

Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 32769 bytes) in /var/www/html/manage/easypopulate.php on line 1226
__________________________________________________ ____

Please guide me regarding this. I have updated product names and I want to replace the product names only.

Thanks
Priya J.

[pgmarshall]

If you are only changing the products_description using a simple set of rules you may find it easier to make the changes directly in the dbase.

1. Backup your dbase - (you have been warned!)
2. Open phpMyAdmin (or similar)
3. Run the following :

UPDATE products_description SET products_description = Replace(products_description, '#', '')

Will remove all the #s. Now just replace the other characters you don't want %^&*>< etc.

You may want to TRIM the results to remove and spaces at the start and end of the field ...

Using the syntax:

REPLACE(stringToLookIn, stringToMatch, replacementsString)

You should be able to replace pretty much anything quickly and easily ...

Regards,

[priyaj1023]

Thanks for your reply, but I want to change the product names.
I have already removed the special characters from Product Names.

I have a list of all 15110 products with updated product names.

How can I upload these products?

[ridexbuilder]

Assuming that you have unique model numbers (which you really should have, if using EP), then just split the upload file. Try 1000 products at a time, if that doesn't work, 500, then 300.....

The only columns that you need are:
v_products_model, v_products_name, EOREOR

Or use a CSV import with phpmyadmin.

[priyaj1023]

I have uploaded and split the file using below
Upload and Split EP File - Split File

Then use the splitted files from temp directory.
Import EP file from Temp Dir - Update Only - Insert into db

Its showing below message but, Product names are not updated.
Easy Populate 2.76i-MS2 - Default Language : english(1) Filename: EP_Split36.csv

Can you please guide me in details?

Regards
Priya J.

[ridexbuilder]

"Cobra XRS 9730 12 BAND RADAR / LASER DETECTOR" - doesn't look like a model number to me! Just one example. Unless you have extended the model number field to some crazy length, then you will have issues. Model numbers shouldn't have spaces... Look at stickers on items around the house... Model No. could be ISBN, EAN, SKU, Barcode... I could go on.


Export to csv from phpmyadmin, retaining the product ID, put some sensible model numbers in (plus your changes) and re-import. [OpenOffice typically copes better than Excel.] As a bonus, it will possibly only need the file split into 2 or 4 parts, if not able to import the complete file.

[pgmarshall]

How many characters have you removed?

If you don't have unique product model numbers then you will probably have to use SQL.

It is pretty quick - you just have to run that one line I posted for each character you want to remove ...

[priyaj1023]

What is mean by Phpmyadmin?
Can you please do this for me?

shall I give you login id and password for my store?

Thanks in advance.

Regards
Priya J.

[pgmarshall]

What is mean by phpMyAdmin?

It is a tool for editing your database - most web hosts have cpanel or similar allowing you to log in and edit your database directly. You would get access to this tool through you web host not your store login.

shall I give you login id and password for my store?

Whilst I am happy to help people out - I don't normally do work like this for them ... You could send a message to RidexBuilder who I know does consultancy (paid) work for people on these boards.

Regards,

[priyaj1023]

Thanks for your support.