Connectors
Mailstep
Connectors
Mailstep
Description
MailStep specializes in the assembly and packaging of goods.
Connector Details
| Name | Value |
|---|---|
| Platform | Mailstep |
| Auth Type | API Keys |
| Direction | Read |
Supported Data
See the table below for the list of data you can read with the Mailstep connector.
| Table Name | Fields |
|---|---|
| expedition_items | id, user, eshop, warehouse, wms, partner, orderNumber, note, billingFirstName, billingLastName, billingDegree, billingCompany, billingStreet, billingHouseNr, billingZip, billingCountry, billingEmail, billingPhone, billingRegistrationNumber, billingVatNumber, differentDeliveryAddress, deliveryFirstName, deliveryLastName, deliveryDegree, deliveryCompany, deliveryStreet, deliveryHouseNr, deliveryZip, deliveryCity, deliveryCountry, deliveryEmail, deliveryPhone, requiredExpeditionDate, carrier, carrierService, carrierPickupPlace, carrierNote, trackingNumber, trackingUrl, externalTrackingNumber, packagesCount, status, expeditedCompletely, value, currency, fragile, cod, codValue, codCurrency, codVariableSymbol, customerGroup, eshopOrderDate, countOfItems, countOfSku, sumOfQuantity, packedAt, sentAt, deliveredAt, waitBeforeProcessing, editBeforeProcessing, priority, ref1, ref2, ref3, foreignPrice, conversionDate, modifiedAt, invoiceUrl, invoiceOriginalName, withComplaint, createdAt, changedAt, carrierPickupPlaceCode, invoice, items, errors, audits |
| expeditions | id, createdAt, changedAt |
| product_groups | id, name, createdAt, changedAt |
| product_stock | id, product, warehouse, wms, quantity, booked, bookedAtExpeditions, bookedAtTransfers, bookedAtStockChanges, available, missing, missingAtExpeditions, missingAtTransfers, missingAtStockChanges, required, incoming, lots, createdAt, changedAt |
| products | id, eshops, productSku, internalSku, organisation, productGroup, name, description, images, intImages, weight, height, width, length, intWeight, intHeight, intWidth, intLength, referenceNumbers, packagingType, workAroundSnIn, workAroundEanSticker, workAroundWarrantyInf, workAroundLot, active, createdAt, changedAt, countryOfOrigin, hsCode, type, category |
| stock_advice | id, user, organisation, warehouse, wms, supplier, packagingUnit, countOfUnits, status, manualInput, note, internalId, wmsInternalId, mailwiseInternalId, countOfItems, countOfSku, sumOfQuantity, sumOfSuppliedQuantity, ref1, ref2, ref3, expectedAt, createdAt, changedAt |
| stock_advice_items | id, stockAdvice, bookStockAdvices, blocked, position, product, quantity |
| suppliers | id, organisation, name, companyName, firstName, lastName, degree, degree2, street, houseNr, city, zip, country, phone, email, registrationNumber, note, active, ref1, ref2, ref3, createdAt, changedAt |
| warehoue_list | id, name, customId, wms, defaultWms, organisation, createdAt, changedAt |