Import/Export Variant Rules

Export Variant Rules

Step 1: Access Export Page

• Go to the Bulk Import/Export page from the left-hand menu in your app dashboard.

Step 2: Choose Export Option

You’ll be presented with two export options:

• Option A: Export for All Variants
  • Select this if you want to export all product variants (including those with and without any discount rules).
• Option B: Export for Existing Variant Discount Rules
  • Select this if you only want to export variants that already have discount rules applied.

Step 3: Click on Export

Under the Variant Rules section, click the Export button.

Step 4: Download Exported File

• After clicking the Export button:
  1. You will receive a notification confirming the export.
  2. A CSV file will be sent to your store’s registered email address.

Import Variant Rules

Step 1: Download Sample CSV

• Click on Download Sample CSV Template to understand the correct format for your data.
  

Step 2: Export First (Recommended)

• It’s recommended to export your current variant rules first. This gives you a sample file with existing data, which you can modify and re-import.
  

Step 3: Prepare Your CSV File

• Use the exported or sample file to enter your new or updated discount rules.
• Keep in mind:
  • The following fields are for reference only and do not affect the import:
    • Product Title
    • Variant Name
    • Variant SKU
    • Variant Price
  • Variant GID is a required field and used to identify each variant.
  • SKU is optional and used for reference only.

Step 4: Import the File

• Upload the edited CSV file using the Import function.

Note: If you are on the Basic (Free) plan, you can import up to 500 rows per file.

Import History

Step 1: Open History Tab

• Navigate to the History tab from the Bulk Import/Export page.

Step 2: Review Past Imports

• You can view details of your past imports.
• Only imports from the last 7 days will be visible.

Bulk Delete Variants Rules(Using Variant ID)

Note: The Bulk Delete Variant feature is available only on the Platinum Plan. Once subscribed, the button will be enabled in your admin.

Step 1: Export Variant Rules

1. 1. Go to OSCP Wholesale App > Bulk Import/Export > Export.
   2. Export the existing Variant Rules file.

Step 2: Prepare the File

1. Open the exported file.
2. Remove all columns except:
   • Variant ID
   • SKU (for reference only).
3. (Optional) You can also download the sample CSV for Bulk Delete for reference.

Step 3: Mark Variants for Deletion

1. Add a new column named Delete action.
2. For each variant you want to delete, enter Yes in the Delete column.
3. Remove rows for variants you do not want to delete.

Step 4: Upload the File for Bulk Deletion

1. Save the updated file.
2. Important: Take a backup before uploading the file.
3. Go to OSCP Wholesale App > Bulk Import/Export > Import > Delete Variant Rule.
4. Upload the updated file.

Step 5: Verify in Shopify Admin

1. After the import, go to your Shopify Admin.
2. Cross-check that the selected variants have been successfully deleted.