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

Aircut
Member
Registered: 09-22-2003
Posts: 235
Website

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

lgt
Member
Registered: 11-21-2010
Posts: 272
Website

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

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19818
Website

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

 

#4 09-08-2012 04:39:38

Aircut
Member
Registered: 09-22-2003
Posts: 235
Website

Re: in search of a quicker way to set related products

and can you easily relate to a product all the other products in the same category?

Offline

 

#5 09-08-2012 07:55:25

lgt
Member
Registered: 11-21-2010
Posts: 272
Website

Re: in search of a quicker way to set related products

Nick,
Not using the same field.  Using the same backend menu screen:
http://lawn-gardening-tools.com/pic/related-products.png

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

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19818
Website

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

 

#7 09-09-2012 12:11:18

Aircut
Member
Registered: 09-22-2003
Posts: 235
Website

Re: in search of a quicker way to set related products

and can you easily relate to a product all the other products in the same category?

Offline

 

#8 09-10-2012 06:02:39

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19818
Website

Re: in search of a quicker way to set related products

You'd need to set the related products for each of those products by editing each product.


Nick Hendler

Offline

 

Board footer