1 2 3 4 5 6 7
| INSERT INTO products (product_techdata_id ,product_cnet_id ,product_cnet_statut ,products_description ,products_quantity ,products_model ,products_image ,products_price ,products_tax_eco ,products_date_added ,products_last_modified ,products_date_available ,products_weight ,products_status ,products_tax_class_id ,manufacturers_id )
SELECT temp_MaterialFile.Matnr, CNET_ID, 'A', LongDescription, Stock, temp_MaterialFile.ManufPartNr, Imgid,CustBestPrice,Surcharge,now(), '', NextDeliveryDate, Weight,CASE WHEN Stock>0 THEN 1 ELSE 0 END, 1, manufacturers_id FROM temp_MaterialFile
LEFT JOIN manufacturers ON temp_MaterialFile.Manufacturer = manufacturers.manufacturers_name
LEFT JOIN temp_StockFile ON temp_MaterialFile.Matnr = temp_StockFile.Matnr
LEFT JOIN temp_CustSpecific ON temp_MaterialFile.Matnr = temp_CustSpecific.Matnr
LEFT JOIN cnet_prod ON Prodid = CNET_ID
WHERE CNET_ID NOT IN (SELECT product_cnet_id FROM products); |
Partager