To export product data including stock, the following steps are necessary.

• In the menu above products and then via the link on top “Export”. (Located next to “Create” and “Import”.)
• Select columns and select export of metadata.
• Click on the “Generate CSV” button to download a CSV file.

Our WooCommerce plugin writes the tracking number into the order field tracking_number. It is possible that an order consists of several packages and that the tracking numbers are separated by commas in the field.

In addition, the carrierfield is used to enter the shipping service provider (e.g. DHL, DPD, etc.) with which the parcel was sent.

You can use the template customer-completed-order.phpto set the template for sending e-mails. Via the admin menu WooCommerce- > Settings- >E-Mails the template file can be adapted into the template and over it afterwards.

The tracking numbers could be displayed in the file e.g. above the footer, i.e. directly above:

/**
 * @hooked WC_Emails::email_footer() Output the email footer
 */
do_action( 'woocommerce_email_footer', $email );

The following code excerpt reads out the tracking numbers and shows them as DHL link in the e-mail. For production use, you would also have to read out the carrier at this point and put the link together accordingly depending on the carrier.

$post_id = $order->ID;
echo "tracking number for $post_id ";
$tn = get_post_meta($post_id, "tracking_number");
if ($tn) {
 $numbers = explode(',', $tn[0]);
 if ($numbers) {
 foreach ($numbers as $code) {
 echo '<a href="https://nolp.dhl.de/nextt-online-public/de/search?piececode="'.$code.'>'.$code.'</a><br/>';
 }
 }
}

/**
 * @hooked WC_Emails::email_footer() Output the email footer
 */
do_action( 'woocommerce_email_footer', $email );

With the second version of the WordPress plugin, Wemalo has considerably extended the range of functions.

furnishing

• Download and activate the Wemalo Connectplugin from the WordPress shop.
• A user account must then be set up in wemalo-connect(by a Wemalo employee).
• The security key generated in wemalo-connect must be stored in the plugin configuration (a Wemalo entry has been added to the admin menu).

products

• If a product is updated, the change is sent directly to Wemalo via wemalo-connect.
• In addition, the product master data is requested by Wemalo at regular intervals. Since this is primarily required for the initial setup, the frequency of periodic queries is reduced.

mandatory fields

The only real mandatory field is the article number. However, they are also important for the warehouse processes:

• EAN (if article number cannot already be scanned)
• Article dimensions and weight (for storage and shipping)
• Product image (for visual verification)
• Product name (for name matching when picking/packing)

Expansion of products

The plugin extends the products and variants and adds the following information:

• New alternative stock field (for example, B goods)
• new field EAN (Tab Wemalo in main product)
• new setting possibility serial number (Tab Wemalo in main product)
• Overview of serial numbers/batches (Tab Wemalo in main product)

data transfer

• When the main product is saved, the data record is transmitted directly to Wemalo. The time stamp of the last data transfer is displayed in the Wemalo tab.
• A direct transmission also takes place when saving variants. Here the timestamp is displayed in the variant view.
• If an error occurs during transmission, the return of the server is output.

product bundles

• The WooCommerce product Bundle plugin has been supported since version 2.0.2 of the Wemalo plugin. The WooCommerce product Bundle plugin has been supported since version 2.0.2 of the Wemalo plugin.
• As an alternative to using a plugin in WooCommerce, sets can also be defined in Wemalo. To do this, the set product must be created as a normal product in WooCommerce and configured accordingly in Wemalo (done by the Wemalo customer consultant).

orders

• As soon as an order is set to “in progress”, data is transmitted to wemalo-connect and thus directly to Wemalo.
• The download timestamp is set immediately. If an error occurs during transmission, the error message is stored as a custom field.
• If the order could be completely reserved, it changes to a new fulfillment status.
• As long as the order has not been reserved and is being processed in the order, it can also be cancelled in Wemalo using the WordPress stroning function. However, if the order is ready for fulfillment, it must be cancelled manually in Wemalo.
• Once an hour, WooCommerce queries the current order status as long as the order has not yet been reserved.

Update orders

• If the order is not yet in fulfillment, it can be processed at any time.

status extension

• Returns registered (see Returns)
• Returns posted (see Returns)
• Order in fulfillment

If an order was sent to Wemalo, but cannot be set to Wemalo status open there (and thus released for picking), it will remain in processing status in WooCommerce and can still be cancelled from WooCommerce.

Wemalo fields in orders

• Blocked: if the checkbox is checked, a transfer is made to Wemalo and the order is picked and packed. In Wemalo, however, it lands in the status “blocked packed” and is sent only after release.
• Note: the text field can be used to send a note to the picker or packer.
• ETD: if the date field has been set and is in the future, the goods will be reserved, but in Wemalo no pick list can be created yet. Only when the date has been reached, the picking list can be created and the order further processed/sent.

Additionally there is the panel with wemalo with the following data:

• Priority: determines the priority of the order and can be distinguished between normal, high and very high. The priority affects the order of picking and reservation.
• Order: another WooCommerce order can be linked via order, in which the order number is entered. A function that goes beyond this does not exist (no link in wemalo or similar).
• Document upload: enables the upload of documents such as invoices or customs declarations.
• Promi: allows you to mark an order as a Promi dispatch. In addition, a text can be entered which is sent to an e-mail address stored in the configuration. This can be used, for example, to write individual texts for orders and attach them to the packages.
• Shipping: to hire the shipping service provider.
• Product: Depending on the shipping service provider, the shipping products can be selected.
• Returns no SN check: if products contain serial numbers, this flag can be used to switch off the validation of correctly returned serial numbers. The flag is transferred to wemalo when a return is registered.

tracking numbers

Tracking numbers are entered as notes and in the tracking_number field.

If wp_liste for Amazon or Ebay have been installed, the shipping service provider is entered in the field _wpla_tracking_provider (Amazon) / _wpl_tracking_provider (Ebay) and the tracking number in _wpla_tracking_number (Amazon) / _wpl_tracking_number (Ebay).

The tracking number can also be integrated into the e-mails sent automatically by WooCommerce when orders are completed. A manual can be found here: Insert tracking number e-mail at WooCommerce

shipping profiles

An external ID can be stored in Wemalo for matching the shipping profile to be sent. This comes from the WordPress installation and can be found under WooCommerce- > Settings- >Shipping.

Stock

• Wemalo’s doing a stock update. This means that the stocks changed in Wemalo are transferred to the WooCommerce shop at regular intervals. The stocks of A-goods are transferred to the normal warehouse stock. All other stocks (B-stock, C-stock, etc.) are entered in a separate field for alternative stocks.
• In order to be able to transfer stocks to WooCommerce, inventory management must be activated in the products on the shop side.

returns

• The Wemalo API plug-in offers the possibility to turn an order into a registered return. As soon as the status of the order has been changed accordingly, the return is sent to Wemalo.
• The return can then be scanned against the original order and the goods can therefore be validated.
• Wemalo reports the received goods back to the plugin and sets the status to Return booked.

Supported Plugins

Supported WordPress plugins

Supported versions in Plugin 2.x:

Version 1.x

X = > This combination is supported
? => Diese Kombination wird nicht aktiv unterstützt, könnte aber funktionieren
– = > This combination is not supported.

When using the Wemalo API, the following plugins are supported by Wemalo:

• Akismet from Automattic
• FAQ from Etoile Web Design
• Wp Cookie Choice by Marcus Franke
• Yoast SEO from Team Yoast
• WP-Lister for ebay Version 2.0.15 from WPLab
• WP-Lister for amazon Version 0.9.6.31 von WPLab
• WooCommerce Multilingual 4.2.6 (from version 2.0.1) from OnTheGoSystems
• Antispam Bee 2.7.1 by pluginkollektiv
• WooCommerce product bundle (from version 2.0.2)

If other plugins are used in the shop, the functionality of the Wemalo plugin cannot be guaranteed. If necessary, the plugin must be adapted so that it works together with other plugins.

This article refers to version 1.x of the plugin. Click here for version 2.x (http://help.wemalo.com/wordpress-wemalo-api-2/).

—

To update the Wemalo WooCommerce plugin, the plugin must first be deleted and then reinstalled.

To do this, first deactivate the plugin:

Delete afterwards:

And confirm the deletion:

Afterwards it can be uploaded and installed as usual.

This article refers to the plugin version 1.x. There is a separate article about version 2.x.

—

After the Wemalo plugin has been installed in WordPress, it can be paired with Wemalo. To do this, the API WordPress must be selected under Data Exchange and the URL to the shop must be stored.

data subscriptions

Individual data calls can be activated/deactivated via the subscriptions:

• Get WA orders: Orders received in WooCommerce are transferred to Wemalo where they can be processed as goods issue orders. Only orders that have the status “In process” and have already been paid will be sent to Wemalo.
• Get product master data: this option must be selected in order to work with the data from WordPress. This transfers the “simple products” and “variable products” from WooCommerce to Wemalo. For variants, the product name is a combination of the title of the parent product and the individual attributes.
• Transfer GR postings: all goods receipts in the warehouse (goods receipt, returns receipt, inventory entry) are transferred to WooCommerce and the stock of the respective articles is increased accordingly.
• Submit WA postings: Wemalo reports back to WooCommerce when an order has been sent and sets the status to completed. In addition, inventory write-offs and goods issues without WooCommerce reference are returned as inventory changes.

authentication key

After the data subscriptions have been selected and pressed Save, the system generates a token that must be used for authentication:

This key must be entered in the Wemalo plugin:

note in WooCommerce

An article number should also be stored for variants. This is transmitted to Wemalo as SKU. By default, WooCommerce does not allow you to store an EAN for articles. Therefore, this field remains empty in Wemalo. Therefore, only the internal barcode generated by Wemalo or the SKU can be used to scan goods. An alternative would be to deposit the EAN as an SKU.

To note in Wemalo

For orders, the customer (if activated) can choose between national shipping, free shipping, etc.. The ID of the respective shipping option must be entered as Ext. Profile ID in Wemalo in the shipping profiles so that the system selects the correct profile when creating a GI order. The ID of the profile can be found in WordPress under WooCommerce- >Settings- >Shipping:

Download page: WemaloAPI.zip