Bulk Operations

When you're managing dozens or hundreds of products, updating them one at a time isn't practical. CoinDuffle's bulk operations tools let you import, export, and update products in batches using CSV files and built-in batch actions.

CSV Export

Exporting your current product catalog to a CSV file is useful for:

• Creating backups of your product data
• Analyzing your inventory in a spreadsheet
• Making bulk edits offline before re-importing
• Comparing your CoinDuffle inventory with other platforms

How to Export

1. Navigate to Seller Dashboard → Products
2. Click Export (or Export to CSV)
3. Choose what to export:
   • All products — Your entire catalog
   • Filtered products — Only products matching your current filter (category, metal type, status, etc.)
4. Click Download CSV

CSV Export Fields

The exported CSV includes these columns:

CSV Import

Import new products or update existing ones by uploading a CSV file.

Preparing Your CSV

For New Products

Create a CSV with the required columns:

• title (required)
• description (required)
• price or premium (required — depending on pricing type)
• pricing_type (required — fixed or metal_based)
• category (required)
• quantity (required)

Optional but recommended:

• sku — Assign your own SKU
• metal_type — Required for metal-based pricing
• weight and weight_unit — Required for metal-based pricing
• image_urls — Semicolon-separated list of image URLs

For Updating Existing Products

To update existing products via CSV, include the sku column. CoinDuffle will match the SKU to existing products and update the specified fields. Only columns present in the CSV will be updated — omitted columns are left unchanged.

Import Steps

1. Navigate to Seller Dashboard → Products
2. Click Import (or Import from CSV)
3. Upload your CSV file
4. CoinDuffle will parse the file and show a preview of the changes
5. Review the preview carefully:
   • New products — Products with SKUs not found in your store will be created
   • Updated products — Products with matching SKUs will be updated
   • Errors — Any rows with issues will be flagged with the specific problem
6. Confirm the import to apply the changes

Import Tips

• Start small — Test with a few products first to make sure your CSV format is correct
• Use the export as a template — Export your existing products, modify the CSV, and re-import
• Check your SKUs — Mistyped SKUs will create duplicate products instead of updating existing ones
• Image URLs must be publicly accessible — If importing images via URL, they must be downloadable without authentication

Batch Price Updates

For dealers with large inventories, keeping prices competitive requires regular adjustments. CoinDuffle offers batch price update tools.

Updating Metal-Based Premiums in Bulk

If you need to adjust your premiums across many products (e.g., reducing premiums on all silver products by $0.50):

1. Export your products to CSV
2. Filter to the products you want to update (e.g., all silver metal-based products)
3. Adjust the premium column
4. Re-import the CSV

Updating Fixed Prices in Bulk

For fixed-price products:

1. Export your products to CSV
2. Modify the price column
3. Re-import the CSV

Price Adjustment Strategies

• After a significant spot price move — Review and adjust premiums to stay competitive
• Seasonal adjustments — Lower prices on slow-moving inventory, raise prices on in-demand items
• Competitive response — When competitors change prices, adjust yours to maintain your market position
• New cost basis — When your acquisition costs change, update your prices accordingly

Batch Inventory Updates

Keep your inventory counts accurate by updating quantities in bulk:

1. Export your current product catalog
2. Update the quantity column to reflect your actual physical inventory
3. Re-import the CSV

This is especially useful after:

• Completing a physical inventory count
• Receiving new shipments from suppliers
• Reconciling inventory across multiple selling platforms

Batch Status Changes

Update product status in bulk:

Publishing Drafts

If you created multiple draft products and want to publish them all:

1. Export with a status filter for "draft"
2. Change the status column to active
3. Re-import

Archiving Old Products

To archive products you no longer carry:

1. Export the products you want to archive
2. Change the status column to archived
3. Re-import

Handling Errors

Common CSV Errors

Partial Imports

If some rows have errors, CoinDuffle will still import the valid rows. Errored rows are skipped and listed in an error report you can download. Fix the errors and re-import just those rows.

Best Practices

• Always export before bulk updating — Keep a backup of your current data before making changes
• Use consistent formatting — Especially for SKUs, categories, and metal types
• Validate your CSV before importing — Open it in a spreadsheet application to check for formatting issues
• Review the preview carefully — The import preview is your last chance to catch mistakes before they go live
• Update regularly — Schedule weekly or monthly inventory reconciliation to keep your CoinDuffle catalog accurate
• Keep a master spreadsheet — If you sell on multiple platforms, maintain a central inventory spreadsheet and use it as the source for CoinDuffle imports