Jump to content

Platform for producers - Cheatsheet: Difference between revisions

no edit summary
No edit summary
No edit summary
Line 23: Line 23:


=== Product edit form ===
=== Product edit form ===
Producers can manually add or edit products using the regular web edit form.


=== Bulk images upload form ===
=== Bulk images upload form ===
Producers can upload images from multiple products using a single form. Images need to have the barcode in their filename so that we can associate each image file with the right product. We also try to recognize "ingredients", "nutrition", "packaging" etc. in the file names to automatically select the images.


=== Spreadsheet file import form ===
=== Spreadsheet file import form ===
Producers can upload product data with a spreadsheet file (LibreOffice, Excel or CSV). We provide a template file, but producers can use any format for the columns names and order. When the spreadsheet file is uploaded, we try to auto-guess what each column is (based on its title and content), and producers can adjust the matching if needed. The matching is saved for subsequent uploads.


=== GS1 GSDN imports ===
=== GS1 GSDN imports ===
Line 56: Line 62:
Admins of the producers platform can edit organization profiles to list the different GLNs that the organization should be associated with.
Admins of the producers platform can edit organization profiles to list the different GLNs that the organization should be associated with.


==== Handling of conflicts ====
==== Merging of data ====
 
Data from Equadis or CodeOnline will be merged with existing data (if the organization name from the GS1 GLN or party name matches, otherwise the GS1 data will be imported to a different organization).
 
Producers can also send extra data and/or pictures on top of imported Equadis or CodeOnline data, or edit it manually.


==== Equadis ====
==== Equadis ====
Equadis customers can send realtime product data updates to Open Food Facts. On the OFF side, product updates are processed nightly.


==== CodeOnline (under development) ====
==== CodeOnline (under development) ====
CodeOnline publishes an export file in open data. The export is updated monthly.
Admins of the producers platform can edit organization profiles to indicate that the CodeOnline data should not be loaded (for instance if we already have real time data for products of that organization).
==== Handling of conflicts ====
For data that comes from GS1 / GSDN (e.g. through Equadis or CodeOnline Food), we skip the data if it less recent than the last publication date we have in sources_fields:org-gs1:publicationDateTime.
We use lastChangeDateTime if publicationDateTime is not available (e.g. for CodeOnline).
This is to avoid importing monthly exports of CodeOnline over more recent realtime Equadis data.


== Exporting data and photos from the producers platform to the public database ==
== Exporting data and photos from the producers platform to the public database ==
Line 72: Line 95:
Owners are available in the product JSON and can be listed through the /owners facet.
Owners are available in the product JSON and can be listed through the /owners facet.


In the public database, the owner field is imported from the producers platform only for organizations that correspond to producers. It is not kept when the owner is an user, or an organization that corresponds to a label or an external database (e.g. org-label-biopartenaire or org-database-usda).  
In the public database, the owner field is imported from the producers platform only for organizations that correspond to producers. It is not kept when the owner is an user, or an organization that corresponds to a label or an external database (e.g. org-label-biopartenaire or org-database-usda).
 
=== Handling of conflicts ===
 
If a product already has an owner specified in the public database, then exports from a different owner will be skipped. Admins can request an export with "overwrite owner" if they want the export to proceed, in which case the products will be assigned to the new owner.


== Technical details ==
== Technical details ==