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.

Source Distributions

No source distribution files available for this release.See tutorial on generating distribution archives.

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

File details

Details for the file odoo8_addon_sale_order_import_csv-8.0.1.0.0.99.dev7-py2-none-any.whl.

File metadata

File hashes

Hashes for odoo8_addon_sale_order_import_csv-8.0.1.0.0.99.dev7-py2-none-any.whl
Algorithm Hash digest
SHA256 6bac7ebd068849662fc7decc063932869baab3842d6556c562e18d6dd6923324
MD5 38ce4f3f4000da6c8a89f2dae80c3818
BLAKE2b-256 b174633e86b3ea2de50bde23148029b60a0a1db784d7e263d8d1a2db73a43d99

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Depot Continuous Integration Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page