---
title: "Store Inventory Trickle Feed for Click n Collect"
canonical: "https://kb.myframeworks.com.au/space/FRAM/28401638/Store%20Inventory%20Trickle%20Feed%20for%20Click%20n%20Collect"
format: markdown
---
# Overview
The Store Inventory Trickle Feed provides continuous hourly updates of Frameworks inventory throughout the day to the Mitre10 and HTH Click n Collect website, to allow an almost real time sync of inventory.
# How to Process Trickle Feed Data
To setup the exchange of data, complete the following:
## 1. Defining the Click n Collect System Tables
To maintain relevant system settings, complete the following:
1. Click the **Frameworks Menu** and navigate to **System Administration** > **System Tables** > **Miscellaneous Table Maintenance** from the navigation tree.
2. In the search field, enter **clickncollect** and click **Find** to view and maintain the following tables:
- **ClicknCollect Directories**
- **ClicknCollect SFTP Login settings**
- **ClicknCollect SFTP Scripts**
3. Click the **ClicknCollect Directories **hyperlink to view and maintain the click and collect directory settings. Click **Save** to finalise any changes.
For more information about the ClicknCollect Directories settings, click here.
| **Fields** | **Description** |
| --- | --- |
| **Code** | Check **Directories **is entered as the **Code**. |
| **Description** | Check **ClicknCollect Directories **is entered as the **Description**. |
| **Upload Directory** | The **Upload Directory **will be typically defined as **/prostix/{environment}/dmp/clickncollect/output/**
> ℹ️ This path may differ slightly depending on your frameworks environment. For example, {environment} maybe /live/ or /demo/. |
| **Poll Directory** | The **Poll Directory **will be typically defined as **/prostix/{environment}/dmp/clickncollect/input/**
> ℹ️ This path may differ slightly depending on your frameworks environment. For example, {environment} maybe /live/ or /demo/ |
> ⚠️ The directories will be created on your Frameworks server as a part of deployment.
4. Click the **ClicknCollect SFTP Login Settings **hyperlink to view and maintain the relevant settings. Click **Save** to finalise any changes.
For more information about the ClicknCollect SFTP Login settings, click here.
| **Field** | **Description** |
| --- | --- |
| **Code** | Check **Login **is entered as the **Code**. |
| **Description** | Check **ClicknCollect Login Details **is entered as the **Description**. |
| **Use (S)FTP Scripts** | Enable to use the secure file transfer protocol (SFTP) scripts are used to securely transfer your data. |
| **(S)FTP Port** | Check the correct SFTP port is entered. Typically port **22** is used for SFTP. |
| **Host** | Check the correct SFTP server hostname is entered. For example [sftp.yourdomainname.com](http://sftp.yourdomainname.com/) |
| **User** | Check the correct SFTP username, for the Host, has been entered. |
| **Password** | Check the correct SFTP password, for the Host, has been entered. |
5. Click the **ClicknCollect SFTP Scripts** hyperlink to view and maintain the relevant settings. Click **Save** to finalise any changes.
For more information about the ClicknCollect SFTP Scripts settings, click here.
| **Fields** | **Description** |
| --- | --- |
| **Code** | Check **Scripts **is entered as the **Code**. |
| **Description** | Check **Upload and Poll Scripts **is entered as the **Description**. |
| **Upload Script** | The path for the location of the **Upload Script **( push files to a remote SFTP site)will be typically defined as **/prostix/{environment}/deploy/scripts/fw_sftp_upload.sh**
> ℹ️ This path may differ slightly depending on your frameworks environment. For example, {environment} maybe /live/ or /demo/ |
| **Poll Script** | The path for the location of the **Poll Script **( download files from a remote SFTP site) will be typically defined as **/prostix/{environment}/deploy/scripts/fw_sftp_poll.sh**
> ℹ️ This path may differ slightly depending on your frameworks environment. For example, {environment} maybe /live/ or /demo/ |
> ⚠️ The directories and script files will be created on your Frameworks server as a part of deployment.
## 2. Setting Up the Click n Collect Inventory Scheduled Task
To setup the schedulable task **Click n Collect Inventory Scheduler**, complete the following:
### 1. Accessing the Click n Collect Inventory Scheduler
On the [About the Frameworks Home Dashboard](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28379174), under **My Shortcuts,** perform the following to access the **Click n Collect Inventory Scheduler.**
1. Click **Add**.
2. Close the **Select an activity to add to your shortcuts **window.
3. In the search field, enter the activity ID **ClickNCollectInventorySched**
4. Click **Finish**.
5. Click the **Click n Collect Inventory Scheduler **hyperlink to open the scheduler.
### 2. Confirming the Scheduled FTP Settings
On the **Scheduled FTP Settings **tab, review each field and adjust as necessary.
> ℹ️ The information displayed in each field is as defined in the miscellaneous tables above.
### 3. Scheduling Hourly Updates
Navigate to the **Schedule** tab to schedule the task. It is strongly recommended to schedule this task to run hourly. To do so, complete the following:
1. Select the **Repeating **option
2. Enter the **start** date and time or use the **Date Picker** icon.
3. Set to **Recur every 60 mins**
4. If required, set a **Between **time range for the hours you want to run the task, for example, 8:30 - 17:30.
5. Enable the days you want the updates to run.
6. Click **Submit** to schedule the task.
Steps for version earlier than 6.1
Navigate to the **Schedule** tab to schedule the task. It is strongly recommended to schedule this task to run hourly. To do so, complete the following:
1. Select the **Daily** option.
2. Enter the start date and time, or use the **Date Picker** icon.
3. Set to recur every (1) day.
4. Click **Submit** to schedule the task.
5. Click **New** to start a new submission.
6. Repeat the previous steps but use the same date and add 1 hour to the previous set time (for example, if 16/03/2022 09:00 was used, enter 16/03/2022 10:00)
7. Repeat for every hour of the desired period.
> ⚠️ The **Scheduled FTP Settings** will refresh with every new submission, so be sure to make necessary changes if required.
> ✅ Refer to the [Scheduled Task - Scheduling and Output ](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28402256)user manual for more information.
# Additional Information
Click here to learn more about how this process works.
1. This scheduler receives the OLP file from the SFTP server's OLPOUT directory.
2. After being read, the OLP file is then stored in the Frameworks archive directory: */prostix/(environment)/dmp/clickncollect/input/(storeId)/archive*
3. The Products from the file are then validated against the Frameworks system, and a response ROP file is then sent to the SFTP server's INCOMING directory.
4. The ROP file is also stored in the Frameworks archive directory: */prostix/(environment)/dmp/clickncollect/input/(storeId)/response/archive/*
5. The Products from the OLP file are saved against the cnc_prod database table.
6. The scheduler then sends the STF file to the SFTP server's INCOMING directory.
7. The STF file is created containing the Product details for each of the Products in the cnc_prod database table.
8. The STF file is also stored in the Frameworks archive directory: */prostix/(environment)/dmp/clickncollect/output/(storeId)/response/archive/*