Hi David,
I'm just about to embark on an extensive product mapping exercise and was thinking about possible ways to lighten the load!
To start with I'll be doing quite a bit of data trudging work using the helper.php file you created. I'll then be left with a long list of master product titles & corresponding alternative names. Some will be NEW master products and some will be existing master products I've already mapped that need to be tweaked.
Rather than have to load these new & modified master products in one by one using the usual product mapping interface I was wondering if there was a clever way of doing this with the long list I'll be creating.
Regarding the existing master product mappings, I was hoping I could somehow overwrite the existing alternative names with new tweaked alternatives.
Hope this makes sense and is possible!
Many thanks,
Neil
Brilliant Dave - this is going to make life so much easier :-)
Cheers,
Neil
Hi David,
Could you send me the support scripts as well? (pmexport.php and pmimport.php?
regards,
B.
Can i request a copy of these as well.
Cheers :)
Hi KGP,
Seems to be a popular one so I've posted the files to the Downloads page...
Upload both to the /admin/ folder of your site. pmexport.php generates the productmapping.txt file for download. You can then edit and maintain this file on your local computer, either in a text editor or spreadsheet. The format is
Master Product Name
Alternative 1
Alternative 2
^ TAB character
Just use a single TAB in front of each alternative, so using a spreadsheet to edit the file, when you save (File > Export), use Tab Separation (and unquoted text).
If you have a large number or product mappings already in place use the Database Tool to create a backup of your existing mappings first!
Cheers,
David.
--
PriceTapestry.com
"Upload both to the /admin/ folder of your site. pmexport.php generates the productmapping.txt file for download"
Just tried that and all I get is an empty .txt file!
I'm using the latest version of PT, any suggestions what I might be doing wrong ?
Thanks.
Graham
Hi Graham,
Assuming there are entires included in Product Mapping, if you enable database debug mode by changing line 7 of config.advanced.php to:
$config_databaseDebugMode = TRUE;...and then download the output from pmexport.php that should give some indication as to the problem - if you're still not sure if you could let me know what is displayed I'll take a look..
(don't forget to disable debug mode again by setting $config_databaseDebugMode back to FALSE) after running the test...)
Cheers,
David.
--
PriceTapestry.com
Hi David,
the process seems to work as it should, it's just that the resulting productmapping.txt file is empty ! There are no error's as such.
Thanks.
Hi Graham,
I just double checked the script from the downloadExtras page and seems to be working fine when browsing to pmexport.php from the /admin/ folder.
If it's still not working for you could you possibly email me a link to the installation and any password required for /admin/ and I'll take a look for you...
Cheers,
David.
--
PriceTapestry.com
Hi David,
I've got a question for you regarding productmapping via pmexport.php and pmimport.php.
The scripts all work fine, however is it also possible to include the other product mapping feelds in the scripts such as: Custom Description: & Custom Category & Custom Brand & Custom Image URL?
At this moment only the manual product description and the =alternative are ex- en imported. Hopefully this can be expanded with the other feelds.
Thanks in advance!
Kindest regards,
Jaimy
Hello Jaimy,
Apologies for the delay in your comment appearing I moderate all posts before publishing in order to protect customer information , URLs etc.
I have just posted an updated version of the pmexport.php and pmimport.php scripts to the more downloads page in the file ProductMappingImportExportCustom.zip
Cheers,
David.
--
PriceTapestry.com
Hi David,
This script is absolutely wonderful now, exactly what I need and it will save a lot of work.
Thanks for your quick response and brilliant service!
Best regards,
Jaimy
Hi David
How to use ProductMappingImportExportCustom ??..I know used TAB for alternate name but how can enter custom field like category etc.
Hi Amin,
The custom fields are tab separated along the first row of each mapping, with the alternatives on subsequent rows indented by a single tab, e.g.
MasterProductName[TAB]Description[TAB]Category[TAB]Brand[TAB]ImageURL[TAB]
[TAB]Alternate1
[TAB]Alternate2
The easiest thing to do is probably to do an export, then you can see the exact format from that...
Cheers,
David.
--
PriceTapestry.com
Hello David,
This script only overwrite alternate name ...but can be possible to add alternate with existing alter name (Not be overwrite)
Example :
Nokia Asha 302
=Nokia asha 302(Black)
=Nokia asha 302 mobile phone
=Nokia asha 302 Phone
This alter name already in productsmap table ..
After that I created one file .....this export file looks like
Nokia Asha 302
=Nokia asha 302(white)
=Nokia asha 302(Pink)
After that I export productsmap.txt .......
So in database can me made like :
Nokia Asha 302
=Nokia asha 302(Black)
=Nokia asha 302 mobile phone
=Nokia asha 302 Phone
=Nokia asha 302(white)
=Nokia asha 302(Pink)
not only two altername
Thanks
Hello Amin,
Sure - I'll email you a version of pmimport.php that merges the export file with the existing `productsmap` table rather than overwriting it...
Cheers,
David.
--
PriceTapestry.com
Hi,
Tnx for Modified Version........I try this version but does not adding any new alternate names.
...............
Thanks
Hi Amin,
I'll check it out on my test server and follow up by email for you...
Cheers,
David.
--
PriceTapestry.com
Hi David,
I wanted to see if this is still viable or if there's some other method? I was considering building something to handle this and bulk ASIN mapping but wanted to check what might already be available before I start down that road.
Hello and welcome to the forum!
I've enabled the Product Mapping Import / Export download - link updated in this comment above...
Cheers,
David.
--
PriceTapestry.com
Hi Neil,
Sure is - I have a couple of support scripts; pmexport.php and pmimport.php that should help - will email them to you now..
Cheers,
David.
--
PriceTapestry.com