OXID Enterprise Ed. 5.2 Shop-Relationships Handling

A note to OXID Enterprise Ed. developers that handling of shop-relationships has changed in OXID EE 5.2.x. Earlier version used to differentiate between master and sub-shops using columns OXSHOPINCL and OXSHOPEXCL. e.g. In OXARTICLES items where differentiated at shop-level based on above columns.

But in the 5.2.x series the relationship presentation has changed. There is only one column called OXMAPID instead of (OXSHOPINCL and OXSHOPEXCL). This column is then referenced to table ending with name *2shop. e.g OXARTICLES2SHOP. Its the same concept used in OXOBJECT2* tables where we have source-id and target-id(reference-id).

Below are the such tables using the references:

  • oxarticles2shop
  • oxattribute2shop
  • oxcategories2shop
  • oxdelivery2shop
  • oxdeliveryset2shop
  • oxdiscount2shop
  • oxfield2shop
  • oxlinks2shop
  • oxmanufacturers2shop
  • oxnews2shop
  • oxselectlist2shop
  • oxvendor2shop
  • oxvoucherseries2shop
  • oxwrapping2shop
​Below is the table structure​:
 ​
 mysql> desc oxarticles2shop;
 +---------------+------------+------+-----+------------------
 | Field         | Type       | Null | Key |
 +---------------+------------+------+-----+------------------
 | OXSHOPID      | int(11)    | NO   | PRI |
 | OXMAPOBJECTID | bigint(20) | NO   | PRI |
 | OXTIMESTAMP   | timestamp  | NO   |     |
 +---------------+------------+------+-----+------------------
nebiz logo

Industriestraße 24b D-70565 Stuttgart – Deutschland

Tel. +49-711-7947-2394 Email. beratung@nebiz.de

© 2018 NEBIZ®

Über uns

NEBIZ® ist Ihr Partner für die Entwicklung erfolgreicher e-Commerce Lösungen. Wir liefern Ihnen leistungsfähige Technik und sinnvolle Beratung, damit Sie sich ganz auf Ihr Kerngeschäft konzentrieren können.

Neben unserem Umsetzung- und Programmierung-Know-how stehen wir Ihnen mit Online Marketing zur Seite.