ax_backend_api v1.0.0

AX Backend

Rebuild SagGwsCatItemEntity_map

AX_CIN_MAPPER

Find issues in SagGwsCatItemEntity_map

SELECT i.CATALOGITEMNUMBER, i.MANUFACTURER, i.MANUFACTURERITEMNUMBER, im.CATALOGITEMNUMBER, im.MANUFACTURER, im.MFIN_TRIM
FROM SagGwsCatItemEntity_map im
JOIN SagGwsCatItemEntity i
ON im.CATALOGITEMNUMBER = i.CATALOGITEMNUMBER
WHERE im.MANUFACTURER != i.MANUFACTURER;

SELECT i.CATALOGITEMNUMBER, i.MANUFACTURER, i.MANUFACTURERITEMNUMBER, im.CATALOGITEMNUMBER, im.MANUFACTURER, im.MFIN_TRIM
FROM SagGwsCatItemEntity_map im
JOIN SagGwsCatItemEntity i
ON im.CATALOGITEMNUMBER = i.CATALOGITEMNUMBER
WHERE im.MFIN_TRIM != REPLACE(i.MANUFACTURERITEMNUMBER, ' ', '');

Extract single article from DB

mysqldump -u USERNAME -p ax_30DA \
  SagGwsCatCategoryEntity \
  BC_Validation_Join \
  article_inventory \
  SagGwsCatExternalCodeValueEntity \
  SagGwsCatItemApprovedVendorListEntity \
  SagGwsCatItemBarcodeEntity \
  SagGwsCatItemEntity \
  SagGwsCatItemEntity_map \
  SagGwsCatItemTranslationEntity \
  SagGwsCatUnitOfMeasureEntity \
  SagGwsCatVendRelatedInfEntity --where="CATALOGITEMNUMBER = 1000011555" > 001.sql

mysqldump -u USERNAME -p ax_30DA \
  SagGwsCatItemInventSetupEntity \
  SagGwsCatItemPurchSetupEntity \
  SagGwsCatItemSalesSetupEntity --where="ITEMID = 1000011555" > 002.sql

mysqldump -u USERNAME -p ax_30DA \
  brand_data \
  SagGws_Cms \
  SagGws_Ekg \
  SagGws_Fibu \
  SagGws_Pgrp \
  SagGwsEcoResCategoryEntity_Kgrp \
  SagGwsEcoResCategoryEntity_Pgrp \
  SagGwsEcoResCategoryEntity_Zoll \
  SagGwsEcoResCategoryTranslationEntity_Kgrp \
  SagGwsEcoResCategoryTranslationEntity_Pgrp \
  SagGwsEcoResCategoryTranslationEntity_Zoll \
  supplier_data > general.sql