This guide covers how to import a stocktake from the Ramp Retail Website into the 3rd Party CIN7 platform.
Before importing, the stocktake must be done on handheld scanners. Visit Performing a Stocktake for more information on how to do a stocktake with handheld scanners.
Please import stocktake data before or after trading hours to minimise stock movement during the stocktake.
1. Once a stocktake has been done, it should automatically be synced to Inventory List under Items in your Ramp Retail Web Menu.
2. When you access the Inventory List page, simply click on 'View' on the most recent stocktake or the specific stocktake you wish to synchronize with your CIN7 stock system.
3. While viewing the stocktake, navigate to the 'Reports' section and select 'Variance - External' from the dropdown menu.
4. Once in the Variance Report menu, a report containing the count of items click 'Export' and then 'CSV CIN7'. This will download a csv file that will be used to import the stocktake into Cin7.
5. After downloading the file, make sure to open it in Excel or your preferred CSV viewer.
Verify that all the codes are entered correctly and that the counts and variance columns are accurate. If you find any errors in these columns, refer to Understanding and Adjusting CSV Files to adjust the stock data or contact Ramp Support for further assistance.
6. Copy the right 3 columns of the csv file and paste them into the Update Counts fields in Cin7 and press Process Counts.
7. On the Products Not Counted Page click The Partial Stocktake button labelled 'Continue without not counted products, these will remain in stock', this will add the stocktake to the stock in Cin7 rather than replace all the stock with only this stocktake.
8. The variance page shows the differences that are going to be made to the stock system in Cin7. Verify that the count, stock on hand and variance columns match the ramp and Cin7 systems. Once the data has been verified, click the continue button. 
9. Once complete, a confirmation page will be shown, confirming that the import has been complete without errors. Press the finish button to return to the main stocktake master page.
10. Once returned to the stocktake master page, press 'Sync Latest Data' to update the stock found in the stocktake master page. Ensure that the updated data is correct.
If any errors or issues occur that cannot be solved, please reachout to the Ramp Support team.