Guides and How-to's
Step-by-step guides and how-to articles for getting data into your store: importing products and customers, AI-assisted column mapping, scheduled imports from URL or FTP, Google Sheet–to–store sync, and troubleshooting common file import issues.
We recommend File2Cart for file-based import and scheduled feeds and Sheet2Cart for Google Sheet sync. Use our homepage to choose the right tool, then follow these guides to set up and run imports with confidence.
What you'll find
- Import basics: First-time setup, connecting your store, and uploading CSV or Excel
- Column mapping: Matching file columns to product, variant, and inventory fields—with AI suggestions
- Scheduled sync: URL, FTP, and Google Sheets as recurring data sources
- Platform-specific: Shopify, WooCommerce, Wix, BigCommerce—see our platform guides for more
- Troubleshooting: Validation errors, format issues, and common import fixes
Mastering Regex for Ecommerce: Taming Semi-Structured Product Data
Learn how to use regular expressions (Regex) to efficiently extract and clean semi-structured product data in spreadsheets, overcoming challenges like greedy matching for your ecommerce catalog.
Navigating UK to EU Import Taxes: A Comprehensive Guide for Ecommerce Sellers
Understand and communicate UK to EU import taxes effectively. Learn about the €150 customs duty threshold vs. universal VAT, and strategies to prevent customer dissatisfaction for your online store.
Unlocking Organic Growth: A Strategic Guide to Promoting Your Online Store
Discover data-driven strategies for promoting your online store beyond personal networks. Learn to master SEO, leverage social media, and optimize product data for sustainable growth.
Preserving Precision: Tackling E+15 Errors in Your Ecommerce Spreadsheets
Learn how to prevent and fix E+15 scientific notation errors in Google Sheets and other spreadsheets, ensuring the accuracy of your ecommerce product IDs, SKUs, and inventory data.
Strategic Breaks: Managing Your Online Store During Temporary Absences
Learn the best strategies for managing your online store during a temporary absence, including vacation mode, extended shipping times, and selective listing deactivation, to protect your sales and search ranking.
Mastering Your Product Catalog: Identifying Duplicates Across Google Sheets
Learn how to efficiently identify duplicate product entries across multiple Google Sheets using conditional formatting and advanced formulas. Essential for clean ecommerce catalog management.
Mastering Data Cleanup: Extracting Names in Google Sheets for E-commerce Efficiency
Learn how to efficiently extract and reformat names (last name, first initial + last name) from your e-commerce data using powerful Google Sheets formulas. Streamline your catalog, customer, and supplier management.