Shopify Import Options | DropSynco Inventory Management Shopify App

Fields Editor

Fields Editor is an optional feature that allows you to manipulate the text of the Title, SKU and Barcode fields.

To perform a text replacement, place the text you want to replace in the Value box and the new text in the New Value box. Next, select the respective product field.

Example: To replace "Red" with "Blue" in the Title field, input "Red" in the Value box, "Blue" in the New Value box, and select "Title" from the product field list. All Title strings containing the text "Red" will be replaced with "Blue."

For more advanced scenarios, utilize Regular Expressions by checking the "Replace using regular expressions" checkbox. Refer to our documentation page for detailed information on Regular Expressions (RegEx).

By default, Replacers are applied across all products. If you need to apply them to a specific subset of products, employ product filters. For detailed guidance, consult the "Product Filters" section.

Product Filter

Product Filter is an optional feature that allows you to filter the products you want to insert or update to your Shopify Store. Any product not matching the filter rules defined will be ignored.

You can combine multiple filters and they are applied in the order of their creation.

You can create a filter for the following fields Title, Description, Vendor, Product Type, Price, Compare Price, and SKU.

Some fields are text fields while others are numeric fields. Based on the type of the field, you can define different rules; for example, you can filter all products with Title (Text Field) containing "Red" or filter products with Price (Numeric Field) greater than 10.

Price Rules

Price Rules are optional. That feature allows you to define the price rules to be applied to your products.

Price rules can be applied across all products or to a selection of products thanks to the product filter rules of this section. To reveal the price rules product filters, switch off the control "applied to all products".

You can create one or more price rules and they are applied in the creation order.

In each rule, it's possible to increase or decrease the price by percentage; for example increasing the price by 10%, or by a fixed amount; for example, increasing the price by 10$.

Notice that the percentage value is always applied before the fixed amount; for example, a 100$ product with a price rule of 10% and 5$ will have a final price of 115$.

Price rules also give the option of rounding prices; for example, if the product price is $10.88 and needs to be rounded to $10.99, you have to add 99 in the rounding box.

Update Options

This section allows you to set the following properties for the feed task:

Published

This option can be set to "Yes" or "No".

Yes: products are visible on your public Shopify store
No: products are not visible

Taxable

This option can be set to "Yes" or "No".

Yes: your country tax fee (VAT) is added by Shopify to the product prices
No: your country tax fee (VAT) is not added

Require Shipping

This option can be set to "Yes" or "No".

Yes: products are physical items
No: products are digital items

Inventory Location

This option can be set to "All" or to any of the store location.

All: product quantities will be updated across all inventory locations.
Your store location: product quantities will be updated only to the selected location (i.e Epcot Center, Lake Buena Vista, FL, 32830, US).

Update Type

This option can be set to "Upsert", "Update" or "Insert".

Upsert: will update existing products and insert new products
Update: will only update the existing products in your store and ignored the other ones.
Insert: will only insert new products.

What shall we do with the product that has 0 quantity in the file?

This option can be set to "Set Quantity to Zero" or "Set Product not Published".

This setting only modifies the products that were uploaded to the store using this file, but their quantity has changed to 0 since then.

How can DropSynco recognize the products which are already in your store?

This option can be set to "SKU", "Product Title", "Handle", or "Barcode".

If you already have products in your store uploaded from this file, and you would like to modify them now, select how DropSynco can recognize them in your store to avoid duplicates.

How can DropSynco recognize the product variants which are already in your store?

This option can be set to "Options", "SKU" or "Barcode".

DropSynco can recognize your product variants by Options, SKU or Barcode, select the most appropriate property to identify existing variants in your Shopify store.

Regardless of which property you want to use (Options, SKU or Barcode), make sure you’ve mapped that property previously in the mapping step.

Group Products and Variants by Unique Identifiers?

This option can be set to "Yes" or "No".

It's common in CSV, TXT and Excel files to have one row for the product details and multiple rows for each variant, when this scenario occurs, rather than process the entire file row by row, it's suggested to group the products by the product and variant unique identifiers. Setting this option to Yes let DropSynco grouping the products by product and variant unique identifiers.

The option is enabled for CSV, TXT and Excel files when the Update Type selected is Upsert or Update.

Which fields would you like to update?

This option allows you to select the product properties that you want to update. Notice that only the properties mapped in the Mapping step will be shown.

Schedule

This section allows you to schedule the feed task based on the time zone associated with your account. You can see or edit that time zone on the "my account" page.

In addition, once the task is created you will have the option to manually run the feed task from the feed task page or the feed task details page.

We recommend selecting "no schedule" and running the task manually for testing purposes.

Like any other task properties, you can change or pause/unpause the schedule at any time in the future by editing the feed task.

Here are the schedule options:

No Schedule

Feed Task is not scheduled and it can be executed only "On-Demand" by clicking on the "Run" buttons from the feed task page or task details page.

Scheduled for a specific date

Shopify product upload, Schedule for a specific date

It allows you to schedule the feed task on a specific date and time. Knowing that a feed task cannot be scheduled on the current date.

Daily Schedule

The feed task will be executed every day at the time selected.

Weekly Schedule

The feed task will be executed only on the weekday(s) and time selected.

Monthly Schedule

The feed task will be executed on a specific day of the month, every month.

Annually Schedule

Shopify product upload, Anually Schedule

The feed task will be executed on a specific day of the year, every year.

Schedule date and time guarantee the start of a feed task execution. Please consider that the task execution might take several minutes up to several hours depending on the number of products to process.

Notice that the schedule of a feed task is added, refreshed, or removed by DropSynco every 10 mins; for example, 8:10, 8:20, etc. for this reason we suggest scheduling the Feed Task at least 10 mins after the current time.