> ## Knowledge Base Index > Fetch the complete knowledge base index at: https://help.syncspider.com/sitemap.xml > Use this file to discover available pages before exploring further. > Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash). # Draft Deleted Products - Shopify to Dokan- Help Center - SyncSpider **TABLE OF CONTENTS** * [Description](#Description) * [Step 1: Shopify to CSV Task](#Step-1%3A-Shopify-to-CSV-Task%C2%A0)  * [1.1 Starting the Task and Selecting Integrations](#1.1-Starting-the-Task-and-Selecting-Integrations) * [1.3 Configuring the Target Integration (Custom CSV)](#1.3-Configuring-the-Target-Integration-(Custom-CSV)) * [1.4 Mapping](#1.4-Mapping) * [1.5 Setting Task Automation](#1.5-Setting-Task-Automation) * [Step 2: CSV to Dokan Task](#Step-2%3A%C2%A0CSV-to-Dokan-Task) * [2.1 Starting the Second Task and Selecting Integrations](#2.1-Starting-the-Second-Task-and-Selecting-Integrations) * [2.2 Configuring the Source Integration (Custom CSV)](#2.2-Configuring-the-Source-Integration-(Custom-CSV)) * [2.3 Source Filtering](#2.3-Source-Filtering%C2%A0) * [2.4 Step 4: Configuring the Target Integration (Dokan)](#2.4-Step-4%3A-Configuring-the-Target-Integration-(Dokan)) * [2.5 Mapping](#2.5-Mapping%C2%A0) * [2.6 Setting Task Automation](#2.6-Setting-Task-Automation) * [Additional Resources](#Additional-Resources) --- ## Description In this article, we explore a common use case for SyncSpider: automating the management of deleted products from **Shopify** to **Dokan**. Specifically, this process involves transferring product information from Shopify to a CSV file and then updating Dokan to mark deleted products as drafts. To achieve this, we will configure two tasks in SyncSpider. --- ## Step 1: Shopify to CSV Task This first task exports primary product data from Shopify to a **Custom CSV file** hosted on SyncSpider's SFTP server. --- ### 1.1 Starting the Task and Selecting Integrations Begin by creating a new task in SyncSpider and click **'Next'** to proceed. Select **Shopify** as your **Source Integration** and choose the **Product** entity from the dropdown. Select **Custom CSV** as your **Target Integration**, and choose **Custom CSV** as the entity. ![](https://storage.crisp.chat/users/helpdesk/website/-/a/a/0/6/aa06d0f85a6f7800/5200c9e8-d93a-4c8e-850b-a76486_1svxw46.png) **Note:** With a SyncSpider subscription, you gain access to an SFTP server hosted within SyncSpider’s infrastructure. This server will be used to store the CSV file generated by this task. see below example custom CSV integration configuration. ![](https://storage.crisp.chat/users/helpdesk/website/-/2/4/1/8/241846ccd2e97a00/af9c091d-c223-433a-81ec-5bae4a_182fiih.png) --- **1.2 Configuring the Source Integration (Shopify)** ### Configure the source by selecting **All Products** in the "Products to import" dropdown. ### No additional filters are required, so you can skip Source filtering and move on to Target Configuration. ### --- ### 1.3 Configuring the Target Integration (Custom CSV) ### For the target configuration, it is important to first select an SFTP path to the folder where the CSV will be stored.  To do so click on the magnifying glass icon next to the **SFTP path to folder** field, which will open a pop-up window. ![](https://storage.crisp.chat/users/helpdesk/website/-/1/5/0/1/15011747817d3100/0dcf15e0-bd04-4194-bab0-144eb6_4ejrs3.png) From the pop-up, select the "files" folder under **HOME**. ![](https://storage.crisp.chat/users/helpdesk/website/-/8/2/d/9/82d9e478c9bce800/af61d896-5d0f-4cc5-a3cc-e5a3c5_14dlz9g.png) Next, provide a descriptive name for the output file, such as "Deleted Products Draft.csv," to avoid confusion with other CSV files. ![](https://storage.crisp.chat/users/helpdesk/website/-/9/1/a/1/91a135730fdfa000/99a91df5-5592-49f3-936f-fd2c2d_oqvwv.png) Set the export behavior to **Overwrite file each time** to ensure the file always reflects the most recent data. ![](https://storage.crisp.chat/users/helpdesk/website/-/7/1/8/a/718a042d31f78800/770a08fb-7388-41a5-a709-4f7620_d7xhxm.png) Lastly, create two columns: **Product Code** and **Product Name**. Including the product name is optional but helps with quicker product recognition when reviewing the file. ![](https://storage.crisp.chat/users/helpdesk/website/-/7/7/c/5/77c5a26c26665800/1ad9d1df-58b5-41ed-9b6f-b18f7e_kz186p.png) --- ### 1.4 Mapping Map the **Inventory/Variant ID** from Shopify to **Product Code** in the CSV. Map the **Title** from Shopify to **Product Name** in the CSV. ![](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/3112278356/original/k8XmFhtpGX5mqRy6k-f8AfqyIK1DON105A.png?1732715409) --- ### 1.5 Setting Task Automation On the task settings page, under Task automation,  set the **Trigger** to **Schedule** and the repeat frequency to **Daily**. ![](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/3112282358/original/Bboqfph1bYK0KnB-47So99Mh2j_tHelYqg.png?1732721902) --- ## Step 2: CSV to Dokan Task This second task retrieves data from this CSV and updates Dokan to reflect the necessary changes. Please note that you need to **run the first task** before setting up the second task. --- ### 2.1 Starting the Second Task and Selecting Integrations ### Begin by creating a new task in SyncSpider for the second step of the automation process and click **'Next'** to proceed. Select **Custom CSV** as your **Source Integration** and choose the **Custom CSV** entity. Select **Dokan** as your **Target Integration**, and choose **Product** as the entity. ### ![](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/3112280992/original/qzG_ZmPUUG3YsEV8xxiyvqzEXEgRvX3sIQ.png?1732719510) --- ### 2.2 Configuring the Source Integration (Custom CSV) For the source configuration, begin by locating the file that was generated in the first task. Again, make sure the first task has been successfully run before proceeding; otherwise, the file will not be available. Use the magnifying glass icon in the **SFTP path to file** field to browse and select the appropriate file. ![](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/3112281356/original/-YdBWyWFda74Usu_xDvufCPS8xcBIL09Xw.png?1732720244) In the Record Processing section, select **Import changed data only** to ensure that only products that have been deleted or otherwise modified are imported, and enable the **Track record status** option to monitor these updates. ![](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/3112281442/original/8ky2vvPfkQrMXL8ogy2z7yBZlkzNHclCOQ.png?1732720445) Finally, set **Product Code** as the unique column by checking the corresponding box in the column settings. ![](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/3112281483/original/YdgqigyqqywcxmooNJ1em8XA50U0cSSgqQ.png?1732720519) --- ### 2.3 Source Filtering In this step, you need to apply a filter to ensure only the deleted products are processed in this task. Set the filter as follows: * **Filter By**: SyncSpider Record Status. * **Choose Condition**:  Equals To. * **Enter Value**: deleted. ### 2.4 Step 4: Configuring the Target Integration (Dokan) For the target configuration, you will need to set up the parameters for the Dokan integration as follows: * **Choose Product Unique Identifier Field (UID)**: Select **SKU** as the unique identifier to match products. * **Batch Size**: Keep the default or set an appropriate size based on your data (e.g., 50). * **Create Parent Product Automatically**: Deselect this option to ensure that no new parent products are created. * **Only Update Products**: Enable this option to ensure that only existing products in Dokan are updated. * **Update Only Mapped Attributes**: Enable this option to restrict updates to only the attributes that are mapped in the next step. ![](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/3112281892/original/0o1WhfUIkW48BqwqgaixnAf_uRiiFo3RsQ.png?1732721164) --- ### 2.5 Mapping In this step, you will map the data from the CSV file to Dokan. Start by mapping **Product Code** from the CSV to **SKU** in Dokan. ![](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/3112282334/original/7EN5G26u_hgZW-EZdzIKFwZNjjVhdLoi-w.png?1732721859) Next, map a **Constant Value** from the CSV to **Dokan Vendor**, which will trigger a pop-up window allowing you to select the appropriate Dokan vendor who owns the product. ![](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/3112282215/original/tIWizHe9DBnB3xhYh74V6CwXnIfvw72MmA.png?1732721639) Finally, map **SyncSpider Record Status** from the CSV to **Status** in Dokan. Configure this mapping by setting the **Source Attribute** to **deleted** and the **Destination Attribute** to **Draft** to ensure that deleted products are correctly marked as "Draft" in Dokan. ![](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/3112282283/original/PT_faICwKUb4mvqsK-AF-lqknVXkda6olA.png?1732721757) --- ### 2.6 Setting Task Automation For this task, configure the automation to run after the successful completion of the first task. In the **Task Automation** section, set the **Trigger** to **On event**, and choose **Task succeeded event** as the condition. Then, select the first task (e.g., **Draft Delete Products pt.1**) as the event to trigger this task. ![](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/3112282634/original/LS1LJCpWN5rMUc7l4ZiEYR93a3CpUYXvig.png?1732722278) Congratulations! You have now set up an automated process to update deleted products from Shopify to draft status in Dokan. --- ## Additional Resources For additional information on Shopify, Custom CSV or Dokan check out these resources: * [How to use Variations in Shopify](https://support.syncspider.com/en/support/solutions/articles/3000116004) * [How to integrate Shopify](https://support.syncspider.com/en/support/solutions/articles/3000115557) * [How to integrate Dokan](https://support.syncspider.com/en/support/solutions/articles/3000115554) * [How to integrate Custom CSV](https://support.syncspider.com/en/support/solutions/articles/3000116074) * [SyncSpider Plugin for Dokan](https://support.syncspider.com/en/support/solutions/articles/3000116973) --- Shopify, Custom CSV and Dokan are just some of the tools we support! To check the list of the tools and features we support, please click here! If you don't see your favorite tool on our list, please take the time to send us a request here to create an integration for you or UP-vote it if it's already on the list. We develop integrations based on requests and up-votes :) We hope this covers everything. If you have any further questions or need additional clarification, please reach out to us via [[email protected]](/cdn-cgi/l/email-protection#02717772726d707642717b6c6171726b6667702c616d6f "mailto:support@syncspider.com") or our chat widget!