- Stanley Black & Decker Deutschland GmbH

Assign Stats BMEcat Catalog Check ERP
2026-01-13 16:29:18
2026-01-13 17:48:38
2026-01-13 17:49:45
reset
special
 2026-01-06 08:39:01
2026-01-07 09:02:51
1900-01-01 00:00:00
Katalog Anfrage
Key Value
no75009
erp_supplier_no75009
nameStanley Black & Decker Deutschland GmbH
shortname
vat_registration_noDE815232128
registration_no
eori_no
gln4025894000000
duns
lei
weee
our_account_no1024006
industry_group
discount_general_overall0
managed0
regex_product_no
regex_mpn
regex_gtin
bmecat_download_url
bmecat_last_request2026-01-13 16:29:18
bmecat_last_response2026-01-13 17:48:38
bmecat_last_import2026-01-13 17:49:45
bmecat_contact_salutation
bmecat_contact_firstname
bmecat_contact_lastname
bmecat_contact_email
erp_last_import_data2026-01-06 08:39:01
erp_last_import_price_purchase2026-01-07 09:02:51
erp_last_import_price_sell1900-01-01 00:00:00
cache_validation_product_supplier
cache_validation_product_erp
info
soft_deleted0
uuid6d4b18bd-e8d7-11ed-bd47-0019995469bf
created_at2023-04-18 10:00:52
updated_at2026-01-13 17:49:45
FieldDescriptionCategoryCSS ClassExport/ImportCount
ces_different_supplier_product_noDifferences in supplier product numberemergencyemergencyYes4
ces_different_supplier_product_no_cleanedDifferences in cleaned supplier product numberemergencyemergencyYes2
ces_different_presupplier_product_noDifferences in pre-supplier product numberemergencyemergencyYes0
ces_different_presupplier_product_no_cleanedDifferences in cleaned pre-supplier product numberemergencyemergencyYes0
ces_different_gtinDifferent GTINemergencyemergencyYes0
ces_different_manufacturerDifferent ManufactureremergencyemergencyYes0
ces_different_mpnDifferent MPNemergencyemergencyYes4
ces_different_mpn_cleanedDifferences in cleaned MPNemergencyemergencyYes0
ces_different_blockedDifferent indicates whether the article is blockedcriticaldangerNo0
ces_different_blocked_purchaseDifferent indicates whether the article is blocked for purchasecriticaldangerNo0
ces_different_blocked_saleDifferent indicates whether the article is blocked for salecriticaldangerNo0
ces_different_unit_valueDifferent Unit ValuecriticaldangerYes2
ces_no_unit_for_quantityNo Unit for QuantitycriticaldangerYes0
ces_different_purchase_unitIndicates differences in the purchase unit.criticaldangerNo15
ces_different_purchase_package_unitIndicates differences in purchase packaging unit.criticaldangerNo0
ces_different_purchase_only_in_package_unitIndicates differences in the rule of purchasing only in package units.criticaldangerNo0
ces_mapping_error_presupplierNo mapping exists for the pre-suppliererrorwarningNo0
ces_mapping_error_manufacturerMapping Error (Manufacturer)errorwarningNo313
ces_incomplete_gtin_match_from_erpIncomplete GTIN Match (ERP side)warningwarningNo0
ces_incomplete_gtin_match_from_supplierIncomplete GTIN Match (Supplier side)warningwarningNo4
ces_manufacturer_not_allowedManufacturer Not AllowedwarningwarningNo0
ces_ens_supplierMissing Supplier Data in ERPmissing_erpinfoNo0
ces_ens_presupplierPre-Supplier does not exist in ERPmissing_erpinfoNo0
ces_ens_unitMissing Unit in ERPmissing_erpinfoYes16
ces_ens_gtinMissing GTIN in ERPmissing_erpinfoNo4
ces_ens_manufacturerMissing Manufacturer in ERPmissing_erpinfoNo8
ces_ens_mpnMissing MPN in ERPmissing_erpinfoNo8
ces_sns_gtinMissing GTIN from Suppliermissing_suppliersecondaryNo0
ces_sns_manufacturerMissing Manufacturer from Suppliermissing_suppliersecondaryNo0
ces_sns_mpnMissing MPN from Suppliermissing_suppliersecondaryNo0
Full Set
/opt/plesk/php/8.4/bin/php -dmemory_limit=2G /var/www/vhosts/novashape.com/subdomains/hkn.novashape.com/index.php modul="erp_product" view="check" supplier_no="75009" full_output="false" > /var/www/vhosts/novashape.com/subdomains/hkn.novashape.com/result.html
/opt/plesk/php/8.4/bin/php -dmemory_limit=2G /var/www/vhosts/novashape.com/subdomains/hkn.novashape.com/index.php modul="supplier_product" view="dq" supplier_no="75009" full_output="false" > /var/www/vhosts/novashape.com/subdomains/hkn.novashape.com/result.html
/opt/plesk/php/8.4/bin/php -dmemory_limit=2G /var/www/vhosts/novashape.com/subdomains/hkn.novashape.com/index.php modul="supplier_product" view="assign" supplier_no="75009" full_output="false" > /var/www/vhosts/novashape.com/subdomains/hkn.novashape.com/result.html
/opt/plesk/php/8.4/bin/php -dmemory_limit=2G /var/www/vhosts/novashape.com/subdomains/hkn.novashape.com/index.php modul="supplier_product" supplier_no="75009" full_output="true" > /var/www/vhosts/novashape.com/subdomains/hkn.novashape.com/result.html
Convert
python -m App.BDMI.BMEcatToSQL.CLI --config "C:\Users\gro\OneDrive\HKN\PIM\Scripts\config\bmecat\75009.json" --input "C:\Temp\75009\bmecat.xml" --output "C:\Temp\75009\bmecat.sql

Assign

  • /opt/plesk/php/8.4/bin/php -dmemory_limit=2G /var/www/vhosts/novashape.com/subdomains/hkn.novashape.com/index.php modul="supplier_product" view="assign" supplier_no="75009" > /var/www/vhosts/novashape.com/subdomains/hkn.novashape.com/result.html
  • /opt/plesk/php/8.4/bin/php -dmemory_limit=2G /var/www/vhosts/novashape.com/subdomains/hkn.novashape.com/index.php modul="supplier_product" view="assign" supplier_no="75009" field="special" value="1" > /var/www/vhosts/novashape.com/subdomains/hkn.novashape.com/result.html
  • /opt/plesk/php/8.4/bin/php -dmemory_limit=2G /var/www/vhosts/novashape.com/subdomains/hkn.novashape.com/index.php modul="supplier_product" view="assign" supplier_no="75009" field="nx_assign_status" value="not checked" > /var/www/vhosts/novashape.com/subdomains/hkn.novashape.com/result.html
  • /opt/plesk/php/8.4/bin/php -dmemory_limit=2G /var/www/vhosts/novashape.com/subdomains/hkn.novashape.com/index.php modul="supplier_product" view="assign" supplier_no="75009" field="nx_dataquality_score" value="1" > /var/www/vhosts/novashape.com/subdomains/hkn.novashape.com/result.html
  • /opt/plesk/php/8.4/bin/php -dmemory_limit=2G /var/www/vhosts/novashape.com/subdomains/hkn.novashape.com/index.php modul="supplier_product" view="assign" supplier_no="75009" field="nx_assign_status" value="multidimensional assignment" > /var/www/vhosts/novashape.com/subdomains/hkn.novashape.com/result.html
  • /opt/plesk/php/8.4/bin/php -dmemory_limit=2G /var/www/vhosts/novashape.com/subdomains/hkn.novashape.com/index.php modul="supplier_product" view="assign" supplier_no="75009" field="nx_datacompare_score" value="1" > /var/www/vhosts/novashape.com/subdomains/hkn.novashape.com/result.html
  • /opt/plesk/php/8.4/bin/php -dmemory_limit=2G /var/www/vhosts/novashape.com/subdomains/hkn.novashape.com/index.php modul="supplier_product" view="assign" supplier_no="75009" action=assign_stats value="multidimensional assignment" > /var/www/vhosts/novashape.com/subdomains/hkn.novashape.com/result.html
  • /opt/plesk/php/8.4/bin/php -dmemory_limit=2G /var/www/vhosts/novashape.com/subdomains/hkn.novashape.com/index.php modul="erp_product" view="check" supplier_no="75009" action="full" > /var/www/vhosts/novashape.com/subdomains/hkn.novashape.com/result.html
  • /opt/plesk/php/8.4/bin/php -dmemory_limit=2G /var/www/vhosts/novashape.com/subdomains/hkn.novashape.com/index.php modul="erp_product" view="check" supplier_no="75009" action="new_errors" > /var/www/vhosts/novashape.com/subdomains/hkn.novashape.com/result.html
  • /opt/plesk/php/8.4/bin/php -dmemory_limit=2G /var/www/vhosts/novashape.com/subdomains/hkn.novashape.com/index.php modul="export" view="price" > /var/www/vhosts/novashape.com/subdomains/hkn.novashape.com/result.html

Export

  • /opt/plesk/php/8.4/bin/php -dmemory_limit=2G /var/www/vhosts/novashape.com/subdomains/hkn.novashape.com/export.php supplier_no="75009" > /var/www/vhosts/novashape.com/subdomains/hkn.novashape.com/result.html
pre_supplier_name
Value Count Assign Count Value Mapped Recommendation
manufacturer_name
Value Count Assign Count Value Mapped Recommendation
740056469313no mapping74005 - DEWALT Deutschland STANLEY BLACK & DECKER DEUTSCHLAND GMBH [0]
75009 - Stanley Black & Decker Deutschland GmbH [0]
74005 - DEWALT Deutschland STANLEY BLACK & DECKER DEUTSCHLAND GMBH [1]
order_unit
Value Count Assign Count Value Mapped Recommendation
BOX17910no mappingBOX - Box (5) [2]
C625879297STK
PAK3213no mappingPAK - PAK (2) [2]
SET903no mappingSET - Set (6) [2]
content_unit
Value Count Assign Count Value Mapped Recommendation
C626469313STK
purchase_unit
Value Count Assign Count Value Mapped Recommendation
country_of_origin
Value Count Assign Count Value Mapped Recommendation