How to Export your information from Celerant POS
The following steps should be followed in order to export the maximum amount of information available from celerant’s https://naturedog.pos.cumulusretail.com/backoffice/ platform to Pinogy POS. There are three sections. The Basic Export section covers all information available to be imported outside of historical sales. The Sale Data Export covers the sales history from Celerant. The last section covers submitting the exported data to Pinogy. Basic data is covered if you selected the basic data import option. Sales data is imported if you selected the Sales Data import option on your quote.
Basic Export
Go to https://naturedog.pos.cumulusretail.com/backoffice/ and login.
Click on Customers on left menu and Customers submenu under it.
Click on the Advanced tab and add condition to search customers from by clicking on the Add button.
When the first condition shows, modify it to “Field” → “Last Name”, “Operator” → “Like”, “Value” → “A%”
Check for the No of rows shown as search result, if they are below 1000, another search condition can be added to include last name with other letters until the row count reaches just below 1000 as only 1000 rows can be exported at a time.
CLick on “Actions” button on top right and then on “Print List” from the dropdown.
It will open the list in a new tab, click on the “Column” button and select all columns and click “Apply”.
When the sheet gets updated with the columns, click on “Export” button and then “CSV” button to download the file.
Repeat steps 4-9 to cover all letters and export complete list.
Place the files in a forlder named customers, compress it to a zip file and mail it to imports@pinogy.com.
Click on Product Management on left menu and then on Products Sub Menu.
Click on the Advance Tab and add consition to search products by by clicking on the Add button.
When the first condition shows, modifiy it to “Field” → “Brand”, “Operator” → “in”, “Value” → “(brand shown in the dropdown)”
Check for the No of rows shown as search result, if they are below 1000, another search condition can be added to include other brands until the row count reaches just below 1000 as only 1000 rows can be exported at a time.
CLick on “Actions” button on top right and then on “Print List” from the dropdown.
It will open the list in a new tab, click on the “Column” button and select all columns and click “Apply”.
When the sheet gets updated with the columns, click on “Export” button and then “CSV” button to download the file.
Repeat steps 14-20 to cover all brands and export complete list.
Place the files in a forlder named products, compress it to a zip file and mail it to imports@pinogy.com.
Sales Export