Follow us on Twitter X-Cart on Facebook Wiki
Shopping cart software Solutions for online shops and malls

BCSE Backorder / Preorder with variants and rebuild

 
Reply
   X-Cart forums > X-Cart 4 > Third Party Add-Ons for X-Cart 4
 
Thread Tools
  #1  
Old 10-02-2013, 12:55 AM
 
DanUK DanUK is offline
 

X-Adept
  
Join Date: Dec 2003
Location: UK
Posts: 800
 

Default BCSE Backorder / Preorder with variants and rebuild

Hi, anybody else use BCSE's backorder/preorder mod with variant items?

I've only just discovered this and I don't know if it is by design. If I set up variant items for backorder/preorder it populates the product_preorder table and the mod seems to work fine.

However, when I rebuild variants it loses the backorder information for the variants. I can see what is happening in that the variant rebuild is giving the variants new variantids which now don't match the variantids in the product_preorder table.

Anyone else experience this?

Thanks

Dan
__________________
4.4.2

and

4.6.1
Reply With Quote
  #2  
Old 08-09-2014, 04:31 AM
  vasilis's Avatar 
vasilis vasilis is offline
 

X-Adept
  
Join Date: Feb 2009
Posts: 758
 

Default Re: BCSE Backorder / Preorder with variants and rebuild

Yes, I noticed that too in Gold v. 4.4.5.

it seems that the variants rebuild function func_rebuild_variants() also changes the 'variantid' value of variants under certain circumstances. For example, when importing a part of variants of a product, the rest of the variants are rebuilt, and their variantid values are changed.

For example, in a product with 3 variants, if I import new prices for the two of them (2 rows in the csv import file), variants rebuild will take place and the variantid value of the 3rd variant that was not imported, will be changed.

This means that any references of the variants whose 'variantid' values change, are broken in other tables, in the case that code is not provided for updating the 'variantid' values of those variants in those tables.

But I wonder why on earth should the 'variantid' values change in the variants rebuild functionality, since these compose part of primary key field for other tables.
Reply With Quote
Reply
   X-Cart forums > X-Cart 4 > Third Party Add-Ons for X-Cart 4


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -8. The time now is 03:26 AM.

   

 
X-Cart forums © 2001-2020