Kryptronic Software Support Forum
You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.
#1 09-06-2012 21:37:30
in search of a quicker way to set related products
Is there a way through direct SQL command or something to automatically set as related products all the other products in the same category, and if so, can i run a batch command that will set the related products to existing items....if so i would appreciate some tips
Offline
#2 09-07-2012 07:30:06
Re: in search of a quicker way to set related products
As soon as they get caught up on two custom mods, I am going to commission a third to have the related products add a related to.. column, so I can cross link.
I don't know why there is a separate menu for related products and up-selling when they could have just made two columns.
I really appreciate the up-selling option, I just which it was implemented more efficiently.
Every second I spend wasting my time working takes away from doing something unproductive.
Offline
#3 09-07-2012 16:40:12
Re: in search of a quicker way to set related products
The two are different because some items you may want to display as related, whereas others you may want to upsell. If we had made them the two features use the same field, I think there would be less flexibility and more complaints from users. Luckily, in your case if you just want all of your upsell items to match your related items, execute this SQL in raw db admin:
UPDATE ecom_prod SET xupsell=xprod
Nick Hendler
Offline
#5 09-08-2012 07:55:25
Re: in search of a quicker way to set related products
Nick,
Not using the same field. Using the same backend menu screen:
This will dramatically increase entering and updating products, with the added benefit of more easily visualizing which options to choose.
This is the one feature that I REALLY, REALLY wanted. I mean besides a multi-store option and printing shipping labels directly from BOM and Google Trusted Merchant Store support and (cross that one off, no BBC support for strike) and email marketing support and better follow-up support.
Anyway, this is the next on my list for the custom shop.
Last edited by lgt (09-08-2012 08:13:23)
Offline
#6 09-08-2012 14:59:47
Re: in search of a quicker way to set related products
We can't do what you're looking for without a huge mod to the way the management interface operates. It's two different fields, and unless you've got a ton of cash and nothing better to spend it on, I'd suggest dealing with it the way it is. No offense, but the functionality to do what you want is already in there.
Nick Hendler
Offline