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 | |||