You are here:  » Product mapping import


Product mapping import

Submitted by stevewales20 on Sun, 2013-09-08 19:30 in

Hi David,

I just thought of something and I was wondering the best way to perform it. Basically using the product mappings, Usually a newly mapped product. How difficult would it be to update all those products to reflect the new mappings? so that I don't have to wait till the full import. I find myself importing thousands of products sometimes just to map a few. It's rather silly use of resources.

Would it just be a case of looping through and updating the products?

Thanks,
Steve

Submitted by support on Mon, 2013-09-09 08:02

Hi Steve,

No problem - i've just created and tested a productsmap_apply.php script (13/03A), which I'll email to you now to try. If any other users would be interested in the same; reply to this thread and I'll post to the Downloads page.

Cheers,
David.
--
PriceTapestry.com

Submitted by Mark Hennessy on Wed, 2013-10-09 12:06

Hi David,

Am I able to get a copy of this also?

Submitted by support on Wed, 2013-10-09 12:11

On it's way!

Cheers,
David.
--
PriceTapestry.com

Submitted by ChrisNBC on Mon, 2014-03-10 11:48

Hi David,

Hope you had a good weekend.

Please could you mail me a copy of the above script?

Thanks in advance.

Regards
Chris

Submitted by support on Mon, 2014-03-10 12:07

On way!

Cheers,
David.
--
PriceTapestry.com

Submitted by ivohofland on Mon, 2014-03-10 20:52

I'm interested in this one too! thank you

Submitted by NiceGuyEddie on Mon, 2014-03-10 22:18

Hi David, me too please...

Submitted by support on Tue, 2014-03-11 09:33

Seems to be a popular one so I've posted to the downloads page here...

Unzip, and upload admin/productsmap_apply.php to your Price Tapestry installation.

To add a link to the utility to the Product Mapping page, look for the following code at line 102 of admin/productsmap.php

  require("admin_footer.php");

...and REPLACE with:

  print "<p><a href='productsmap_apply.php'>Apply Now</a></p>";
  require("admin_footer.php");

Cheers,
David.
--
PriceTapestry.com

Submitted by Halion on Wed, 2014-03-12 16:26

This looks a useful helper, but I can't get it to work on v12/10B. Is there a quick modification I can make to the productsmap_apply.php script?

Thanks
Mike

Submitted by support on Thu, 2014-03-13 09:56

Hi Mike,

I've updated the download for all distributions.

Cheers,
David.
--
PriceTapestry.com

Submitted by Halion on Thu, 2014-03-13 12:31

Hi David,

Thx for the update. I downloaded again the latest productsmap_apply.php but sorry to say it still isn't working for me. Product mapping works fine if I redo slow import of the whole csv file, but nothing happens with the apply now script and link, (I'm using 12/10B). Is there something I've missed?
Thanks
Mike

Submitted by support on Thu, 2014-03-13 14:40

Hi Mike / everyone,

I've discovered an issue with table locking on large databases so I'm going to re-work this mod using an alternative approach - i'll update this thread as soon as tested and working (for 12/10B and 13/03A)...

Cheers,
David.
--
PriceTapestry.com

Submitted by NiceGuyEddie on Wed, 2014-03-26 15:06

Hi David,

Any news regarding this mod? I tried the old one and could not get it to work on my installation (13/03A)

Cheers

Eddie

Submitted by support on Wed, 2014-03-26 15:12

Hi Eddie,

I'll prioritise for this week for you, and I'll drop you an email as soon as an updated version is ready to try. Apologies for the delay, it's a surprisingly complex issue (considering it may have to work against databases of many thousands of products!)...

Thanks for bearing with me;

Cheers,
David.
--
PriceTapestry.com

Submitted by NiceGuyEddie on Wed, 2014-03-26 18:51

Thanks David. Really appreciate the support!

Submitted by marco.saiu on Thu, 2017-12-28 23:37

Hello David,

is possible have file productsmap_apply.php ?

Thanks

Submitted by support on Fri, 2017-12-29 08:37

Hello Marco,

I've re-enabled the download referenced in this comment above...

Cheers,
David.
--
PriceTapestry.com

Submitted by marco.saiu on Fri, 2017-12-29 11:39

Thanks