Remapping product images and URLs

[Chadduck]

Good Morning Everyone

Back in December 2024 I created a post Invoice Imported Displays Incorrectly

Finally, I received ONE (1) response in April 2025 from @fzmuhammad that seemed to make sense. However, when I questioned HOW to accomplish what was suggested I never received a reply nor was there any follow up.

Can someone please tell me me HOW to accomplish their suggestion to "run a script or use admin tools to remap product images and URLs to the correct items" ?  Is this accomplished within the backend? Or is it done elsewhere?

@Ivan Holbi @Jack_mcs @pandrei
 

BJ

[Jack_mcs]

@ChadduckHi BJ. I don't know what that person meant for sure but I'm guessing he meant to re-run the import tool. That's what I would try first. Click the tab to clear the existing data and be sure to import the products before the orders. 

[Chadduck]

15 hours ago, Jack_mcs said:

Click the tab to clear the existing data and be sure to import the products before the orders. 

@Jack_mcs

Truly not what I wanted to hear BUT will follow your guidance.  Thank you for an answer.  Will report back the results.

BJ

Edited June 4 by Chadduck

[deansmar]

It never worked for me.. 

i tyred that about 10 times..

[Chadduck]

On 6/3/2025 at 3:51 PM, Jack_mcs said:

Click the tab to clear the existing data and be sure to import the products before the orders. 

@Jack_mcs

Well I did what you suggested but the images are still confused.  
You did mention " Click the tab to clear the existing data" BUT I did not see THAT option.  Where is it located?

BJ

[Jack_mcs]

1 hour ago, Chadduck said:

Where is it located?

See the attached image.

[Chadduck]

@Jack_mcs

Will doing this require the currently entered product information to be reviewed?  In other words, any modifications that were made AFTER the initial import to be re-entered?  The question is prompted because there were many changes made to the wording.

BJ

[Chadduck]

@Jack_mcs @Ivan Holbi @pandrei

WHAT will this do to the already imported data?  REMOVE Everything?  Or will it only remove whatever is imported afterward (e.g. Products)?  I am just wanting to remap the product images.

BJ

[Jack_mcs]

1 hour ago, Chadduck said:

WHAT will this do to the already imported data?

If you select the "remove only ..." button, it will list the parts that can be removed. But it doesn't show reviews so I would think they would be removed. You could use the export tool (in the products section) to export the reviews and then import them afterwards but, until you try it, you can't be sure if that will work or not.

For any live shop, even non-V4 shops, I always recommend having a copy of the shop where things like this can be tested first.

If the only problem is that the images are not correct, I have a script I wrote that might fix that. Please email if you want to try it.

[Chadduck]

22 hours ago, Jack_mcs said:

If the only problem is that the images are not correct, I have a script I wrote that might fix that

@Jack_mcs

Thank you for your assistance and insights.  Based upon further investigation I am uncertain if it will or not...

Apparently during the import - product ID numbers were changed. 

An explanation would be useful -

I picked one of our most commonly purchased items,  
SKU - MCM300 
NAME - Military Childs Medal

Looking at that item in the ORIGINAL store database with phpMyAdmin - it had a product ID of 3222.

In the NEW store the item's product ID Number has been changed and it is NOW product ID 2832.

Looking at the NEW store's database with phpMyAdmin and locating product ID 3222, I discovered that product ID 3222 is now
SKU -  BADGE-AF-082 
NAME - Badge Card, Maintenance (Basic).

It is this image, BADGE-AF-082 - Badge Card, Maintenance (Basic), which is being displayed on the customer's order for the item MCM300 - Military Childs Medal.

Apparently it is NOT that the image being incorrectly displayed it's an issue with the fact that the product IDs were changed.

SO some how, some way I need to get item's product ID to match the ORIGINAL store -OR- get the image numbers changed to match the NEW product ID numbers.

Your thoughts base upon the NEW information?

BJ

[Jack_mcs]

6 hours ago, Chadduck said:

Apparently during the import - product ID numbers were changed. 

Yes, that is correct. I don't know for sure but my guess is they wrote the conversion script that way since there can be multiple shops in V4 and that prevents duplicate ID's, or maybe it was just easier to do that way.

But while the url in V4 can be the same as it was in V2, the default url method is to not use the product ID. So, for your example, the url for the product would be something like https://...com/Badge-Card-Maintenance-Basic

I think you have to have an entry in the SEO title for that to work, or one of those settings. There is an app to keep the url's the same as before but I think it isn't a free one, though I haven't checked lately. If the old url's were rewritten urls, they might be the same as the one above and, in that case, you could add a redirect command to the .htaccess file to get rid of the product ID in the url.

[Chadduck]

@Jack_mcs

Just to be clear with my understanding.

If a customer returns, logs into their account, clicks on the View to review their order, any attempt to click on the item 
SKU - MCM300 
NAME - Military Childs Medal
The link is going to take them to the INCORRECT item
SKU -  BADGE-AF-082 
NAME - Badge Card, Maintenance (Basic).

To your knowledge
Is there ANYWAY to easily disable that linkage?
Is there ANYWAY to easily correct that linkage?

If not, that is going to be REALLY confusing for returning customers.

BJ

[Jack_mcs]

23 hours ago, Chadduck said:

Is there ANYWAY to easily disable that linkage?
Is there ANYWAY to easily correct that linkage?

As far as I know, V4 works off of the model number (SKU) as opposed to the product ID in V2. So if the model numbers are the same, the correct product should load. But I am not 100% sure about that. I do know that the name used in the url comes from the "SEO Page Name" on the SEO tab of the product edit page. You may be able to change that to the old url. If that works, you could use the import/export tool to do many at once. But if you do that, be sure to check browser tags since it may affect the SEO for the page.

You could try either https://www.oscommerce.com/app/seo-name-redirects or https://www.oscommerce.com/app/seoredirects . Their descriptions sound like they would fix the problem but, again, I am not sure.

This problem really needs input from one of the team members.

[Chadduck]

1 hour ago, Jack_mcs said:

This problem really needs input from one of the team members.

@Jack_mcs

FIRST - thank you for your assistance with this.  It is truly and wholeheartedly appreciated.

I TOTALLY agree which was why Ivan and Pandrei were flagged on the original post when I started this topic.  I even flagged the individual that said the images needed to be remapped from my original topic Invoice Imported Displays Incorrectly.  

I am at a loss as what to do because paying for a module and then discovering that it doesn't fix the issue really is not in the budget. 

Again - THANK YOU for your help trying to figure this out.  As of this message - I haven't discovered a viable work around.

BJ

[Jack_mcs]

@ChadduckI've converted quite a few shops and never had that happen. But it is not something I would think to check so maybe it did happen. But assuming it is not a problem in V4, I would guess that something went wrong with the conversion. All I can think to suggest is that you create a new test shop and try the conversion again, paying attention to the mapping option and order of the conversions. If the problem doesn't exist in that shop, you may be able to import the products to the live shop. You don't need to do a whole new install. Just add another shop in your admin and select it when you run the conversion so that the conversion script only works on that new shop.

[Chadduck]

@Jack_mcs

I myself thought it was strange.  However, there was at least one other person that has been following my original topic stating they had the same issue which is why I have pursued getting an answer to it.

As much as I hate to actually do what you have suggested I will have to attempt it.

Thank you again for your tolerance, understanding and working with me.

BJ

Edited June 15 by Chadduck

[deansmar]

And i am still watching..  and waiting for the answer..

Edited Thursday at 08:52 PM by deansmar