Passer au contenu
Français
Centre d'aide Shippingbo
  • Il n'y a aucune suggestion car le champ de recherche est vide.

EXPORT DATA FROM YOUR LOCATIONS

This export allows you to retrieve all the data from the locations created in your Shippingbo account.

 

Benefits of the feature ✨

  • Full visibility : Allows access in one click to all the key information about your locations (stock, products, zones, priorities, etc.).

  • Logistics optimization : Facilitates the analysis and readjustment of storage and picking strategies based on exported data.

  • Increased efficiency : Simplifies location tracking and processing, especially for complex or multi-product warehouses.

 

1. Prerequisites

  • Feature available uniquely for Shippingbo Packs working in Advanced Warehouse, SO Expert Pack.

 

2. How does exporting locations work?

This feature allows you to perform a complete export of the data from your locations created in your Shippingbo account.

 

3. Export the locations

To export your location data, go to the menu Configurations -> File management -> Locations :

You will be able to click on Generate a new export then click on Download :

In the location export, you will find the following information:

- id Location identifier
- name Location name
- priority Location priority
- picking_disabled : Authorization for picking on the location
- stock_disabled Exclude from available stock. If "true" = the stock is excluded, if "false" = the stock is included in available stock
- collocation_enabled Multi-product enabled. If "true" = enabled, if "false" = disabled
- slot_content.id Location Content Identifier
- slot_contents.product_id Product identifier linked to the location content
- products.user.ref Product SKU linked to the location content
- products.title Product title related to content location
- slot_contents.stock : Content storage location
- slot_contents.batch_number Batch number of contents location
- slot_contents.last_preparation_day : Best before date of contents location
- warehouse_zones.name Location area name
- sum(package_slot_reservation.quantity) Quantity reserved in packages

💬 Good to know:

Depending on the number of command lines to be exported, the generation may take a few minutes.

 

4. Configure your export

You can select certain criteria and field configurations for your export.

To do this, go to the menuConfigurations >File management> tab Export>Locations >Configure :

Here you can configure the export format you want by checking/unchecking the listed options.

🚩 Special case:

If your file contains commasin the exported data, select the separator ";"during the configuration of your export.

💡 Trick :

  • If the data format is not displayed correctly, go to the menuDataand select the desired format.

    In OpenOffice Calc, select the column to reformat, then the menuText in columns... : 

    And check the separator that will format your data correctly (in this example,Comma) : 

 

 

⚒️ Framework and responsibilities:

Before fully using the functionality described in this tutorial, it is strongly recommended to performa testing phasefollowing your own parameters to verify that the result meets your expectations. The remaining customerfully responsibleThese tests, based on actions performed on the Shippingbo account, are essential to ensure the tool can be used with complete peace of mind.

 

To go further 🛫: 

- Create locations manually and via import

- Export data from your remote locations

 

Contact us 📬:

Questions about this feature? Feel free to write to us.hereso that we can answer your questions.