====== Magento ====== Magento ist eine weit verbreitete Webshop-Software. Artikelstammdaten können aus mercaware hochgeladen und Kundenbestellungen können heruntergeladen werden. ===== Mapping für Kundenbestellungen (ORDERS) ===== ^Magento ^^mercaware ^^Bemerkung ^ ^Tag ^Format ^Tabelle ^Feld ^ ^ |state |string(8) |ATRIMK |LADEB | | |status |string(8) | | | | |protect_code |string(6) | | | | |shipping-desciption |string(17) | | | | |is_virtual |string(1) | | | | |store_id |string(1) | | | | |customer_id |string(1) | | | | |base_discount_amount |string(6) | | | | |base_discount_canceled |string(6) | | | | |base_discount_invoiced |NULL | | | | |base_discount_refunded |NULL | | | | |base_grand_total |string(8) | | | | |base_shipping_amount |string(6) | | | | |base_shipping_canceled |string(6) | | | | |base_shipping_invoiced |NULL | | | | |base_shipping_refunded |NULL | | | | |base_shipping_tax_amount |string(6) | | | | |base_shipping_tax_refundet |NULL | | | | |base_subtotal |string(8) | | | | |base_subtotal_canceled |string(8) | | | | |base_subtotal_invoiced |NULL | | | | |base_subtotal_refunded |NULL | | | | |base_tax_amount |string(8) | | | | |base_tax_canceled |string(8) | | | | |base_tax_invoiced |NULL | | | | |base_tax_refunded |NULL | | | | |base_to_global_rate |string(6) | | | | |base_to_order_rate |string(6) | | | | |base_total_canceled |string(6) | | | | |base_total_invoiced |string(6) | | | | |base_total_invoiced_cost |NULL | | | | |base_total_offline_refunded |string(6) | | | | |base_total_online_refunded |string(6) | | | | |base_total_paid |string(6) | | | | |base_total_offline_qty_ordered |string(6) | | | | |discount_amount |string(6) | | | | |discount_canceled |string(6) | | | | |discount_invoiced |NULL | | | | |discount_refunded |NULL | | | | |grand_total |string(8) | | | | |shipping_amount |string(6) | | | | |shipping_canceled |string(6) | | | | |shipping_invoiced |NULL | | | | |shipping_refunded |NULL | | | | |shipping_tax_amount |string(6) | | | | |shipping_tax_refunded |NULL | | | | |store_to_base_rate |string(6) | | | | |store_to_order_rate |string(6) | | | | |subtotal |string(8) | | | | |subtotal_canceled |string(8) | | | | |subtotal_invoiced |NULL | | | | |subtotal_refunded |NULL | | | | |tax_amount |string(8) | | | | |tax_canceled |string(8) | | | | |tax_invoiced |NULL | | | | |tax_refunded |NULL | | | | |total_canceled |string(8) | | | | |total_invoiced |string(6) | | | | |total_offline_refunded |string(6) | | | | |total_online_refunded |string(6) | | | | |total_paid |string(6) | | | | |total_qty_ordered |string(6) | | | | |total_refunded |string(6) | | | | |can_ship_partially |NULL | | | | |can_ship_partially_item |NULL | | | | |customer_is_guest |string(1) | | | | |customer_note_notify |string(1) | | | | |billing_adress_id |string(1) | | | | |customer_group_id |string(1) | | | | |edit_increment |NULL | | | | |email_sent |string(1) | | | | |forced_shipment_with_invoice |NULL | | | | |gift_message_id |NULL | | | | |payment_auth_expiration |NULL | | | | |payment_authorization_expiration |NULL | | | |