Is it possible to change product code via import file?

[William Davis]

Is it possible to change product code via import file, if so how? I doubt it, but it does not hurt to ask.

Discovered a couple of hundred product codes with blank spaces when migrating store from MM4.24c to M9.

[lesliekirk]

Not an answer to your question - but a question - what do these links with blank spaces look like? As in how have the search engines picked them up? You may need to use the URI Management to fix these. Sorry, if it's a vague answer, I'm still trying to wrap my head around how to use this to fix a few links I've found on a site that are like this with losing the link juice.

[William Davis]

Not an answer to your question - but a question - what do these links with blank spaces look like? As in how have the search engines picked them up? You may need to use the URI Management to fix these. Sorry, if it's a vague answer, I'm still trying to wrap my head around how to use this to fix a few links I've found on a site that are like this with losing the link juice.

Example:

www.[SITE_NAME].com/[PREFIX]-[PRODUCT CODE].html (The blank space in the product code)

Fortunately, all the links rank well within top 5 90% of the time despite competition.

[wsmith]

Example:

www.[SITE_NAME].com/[PREFIX]-[PRODUCT CODE].html (The blank space in the product code)

Fortunately, all the links rank well within top 5 90% of the time despite competition.

If you used the catalog export from 4.x to create an xml file used to import the products, you can try the following:
1) Edit the catalog xml and remove the spaces from the products and re-import the file. This will create brand new products without spaces and skip any other products that already exist from the first import.
2) Delete duplicate products containing spaces in the code from the catalog screen.

Or
You can edit in bulk off the catalog screen but with a couple hundred this will be a little bit of work.

Or
You can export the products to CSV, remove the spaces from the product codes, delete the products from the store and import the new CSV file with corrected product codes.

I suggest running any of these on a development store (copy of the live) before running it on the live just to make sure.

Another option would be talking with our professional services team regarding a SQL script to remove all spaces via the database.

- Wayne

[William Davis]

If you used the catalog export from 4.x to create an xml file used to import the products, you can try the following:
1) Edit the catalog xml and remove the spaces from the products and re-import the file. This will create brand new products without spaces and skip any other products that already exist from the first import.
2) Delete duplicate products containing spaces in the code from the catalog screen.

Or
You can edit in bulk off the catalog screen but with a couple hundred this will be a little bit of work.

Or
You can export the products to CSV, remove the spaces from the product codes, delete the products from the store and import the new CSV file with corrected product codes.

I suggest running any of these on a development store (copy of the live) before running it on the live just to make sure.

Another option would be talking with our professional services team regarding a SQL script to remove all spaces via the database.

- Wayne

Thanks, we have not gone live yet.

I actually came to the same conclusions. I automatically ruled out your first option because the MM4.24c xml export did not yield the results I had hoped for when it was first done. In retrospect unless I might be missing something, I think I would have been better off exporting/importing through other modules, but not XML.

The second option is too many to manually do it.

The third seems to be the best option, but when I tried to perform and Admin Catalog Product Advance Search for Product Codes with one blank space (so I can select all and delete them) but it did not work.

Is there a way to perform such a search, if so how?