Skip to main content

Import CSV sale order files

Project description

License: AGPL-3

Sale Order Import CSV

This module adds support for the import of electronic RFQ or orders as CSV file. The structure of the CSV file is the same as for the Dilicom plateform (the main plateform to order books in France). It contains 2 columns:

  • the 1st column contains the product code (EAN13 or any other product code),
  • the 2nd column contains the product quantity, using ‘.’ (dot) as decimal separator and without any thousand separator.

It shouldn’t have any header line and use semi-colon as field separator. The CSV file is expected to use UTF-8 encoding ; but as product codes rarely use non-ASCII caracters, the file is identical to an ASCII-encoded file.

Example of an order CSV file:

5410228193449;2
5449000054227;10
5449000111715;5

As the CSV order doesn’t contain any pricing information, the prices are always computed from the pricelist of the customer.

If you want to export an Odoo purchase order as a CSV file, you can use the module purchase_dilicom_csv available on Akretion’s Github.

Configuration

No configuration is needed.

Usage

Read the description of the sale_order_import module for a detailed usage description. As the CSV file doesn’t contain any identification of the customer, when you import a CSV file, the wizard will ask you to select the customer. If you want to test the import of a CSV order and your Odoo database is loaded with the demo data, you can import the file sale_order_import_csv/tests/files/order_file_test1.csv.

Try me on Runbot

Bug Tracker

Bugs are tracked on GitHub Issues. In case of trouble, please check there if your issue has already been reported. If you spotted it first, help us smashing it by providing a detailed and welcomed feedback.

Credits

Contributors

Maintainer

Odoo Community Association

This module is maintained by the OCA.

OCA, or the Odoo Community Association, is a nonprofit organization whose mission is to support the collaborative development of Odoo features and promote its widespread use.

To contribute to this module, please visit https://odoo-community.org.

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Filename, size & hash SHA256 hash help File type Python version Upload date
odoo10_addon_sale_order_import_csv-10.0.1.0.0.99.dev2-py2-none-any.whl (10.3 kB) Copy SHA256 hash SHA256 Wheel py2 Aug 1, 2018

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page