Next-Cart

SQL to Phoca Cart Import

Import products, customers, orders, blog posts, and other supported store data from SQL to Phoca Cart securely and accurately while preserving data relationships throughout the transfer.
SQLSQL to Phoca Cart ImportPhoca Cart
Start Free Demo
No downtime, <br />No coding required
No downtime,
No coding required
Keep your store active during migration. No technical skills needed.
Free Demo Available
Free Demo Available
Preview a sample of your WooCommerce data on Shopify before running the Full Migration.
1-year License with <br />Recent Data Migration
1-year License with
Recent Data Migration
Keep your migration project available for 12 months and sync new or changed data with Recent Data Migration when needed.
24/7 <br />Technician Support
24/7
Technician Support
Get expert help with connections, configuration, migration issues, and validation whenever you need it.

Step-by-Step Guide to SQL to Phoca Cart Migration

Connect your Custom Platform
1
Connect your Custom Platform
Upload the required data files to establish the connection. 
Step-by-Step Migration Guide
icon

Data You Can Migrate

Products
Product Categories
Taxes
Manufacturers
Customers
Orders
Reviews
Coupons
Blog Posts
CMS Page
All relationships (categories, variants, images, etc.) preserved

Customize your setup with additional options Customize your setup with

Recent Data Migration
Clear Target Store Data
Strip HTML Tags from Category and Product Names
Transfer Embedded Images to Target Store
Create 301 Redirects for SEO URLs
Preserve Product IDs & Category IDs
Preserve Order IDs and Customer IDs
Compatibility Overview
SQLSQL
Phoca CartPhoca Cart
Version Rangetooltip
-
1.x – 6.x.x
Language & Localization
-
Multilingual, Multicurrency, RTL, Localized URLs
Main Editionstooltip
-
Phoca Cart extension
Product Types: Simple Product, Variable Product, Downloadable Product
Product Information: Name, SKU, Barcode, Tags, Manufacturer, Status, Visibility
Product Images: Main image, Gallery Images, Alt Text, Position
Product Pricing : Regular Price, Sale Price, Tier Price
Product Options: Name, Stock per option, Position
Product Variants : Variant Attributes, Weight, Stock Quantity, Status
Product Inventory : Manage Inventory, Stock Status, Backorders Allowed
Product Downloads: File name, File URL, Download Limit, Download Expiry, Downloadable File
Multi-language Product Information: Name, Description, Short Description, Attributes
Product SEO / Structured Data: Meta Title, Meta Description, Meta Keywords, URL Path
Product Attributes & Custom Fields : Values, Position, Visible On Product Page, Attribute Groups, Attribute Types
External Links / Relationships : Categories, Related Products, Brands, Manufacturers
Category Information: Name, Description, Status, Meta Title, Meta Description
Category Structure / Hierarchy: Parent Category, Subcategories, Sort Order
Tax Rules: Tax Rule, Tax Class, Country, State, Postal Code, Rate percent, Shipping Taxable, Product SKU
Manufacturer Information: ID, Name, Description
Manufacturer Branding : Logo Image
Manufacturer SEO: Meta Title, Meta Description
Multi-language Manufacturer: Name, Description
Customer Information : First Name, Last Name, Email, Phone, Status, Date Created, Password
Customer Addresses: ID, First Name, Last Name, Company, Address 1, Address 2, City, Province, Country, Zip Code, Phone, Address Type, Default Billing, Default Shipping
Customer Order History: Order ID List
Order Relationships: Linked Customer, Linked Products
Order Information: ID, Number, Status, Currency, Subtotal, Discount, Tax, Total, Payment Method, Shipping Method, Shipping, Tracking, Note, Created Date, Updated Date
Product Details: Product Name, SKU, Quantity, Unit Price, Line Total, Tax, Discount, Options
Customer Details: First Name, Last Name, Company, Street, City, Province, Country, Postcode, Phone
Product Relationship: Product ID
Review Information: Title, Comment, Rating, Status, Date
Reviewer Information: Customer ID, Email, Name
Coupon Information: Code, Description, Discount Type, Discount Value, Status, Start Date, End Date
Usage Restrictions: Minimum Spend, Maximum Spend, Individual Use, Exclude Sale, Products, Excluded Products, Categories, Excluded Categories, Usage Limit, Usage Per Customer
Multi-language Coupon Information: Name, Description
Post Information: Title, Content, Short Description, Tags, URL Path, Status, Visibility
Post Images: Image, Images In Content
Post Categories : Category, Parent, Position
Post SEO / Structure Data: Meta Title, Meta Description
Post Comments: Name, Email, Comment, Date, Status
Multi-language Post Information: Title, Content, Short Description, Meta Title, Meta Description
Page Information: ID, Title, Content, Short Description, URL Path, Status, Visibility, Template, Parent Page ID, Position, Created Date, Updated Date
Page Images: Featured Image, Images In Content
Page SEO / Structure Data: Meta Title, Meta Description
Multi-language Page Information : Title, Content, Excerpt, URL Path, Meta Title
SQLSQL
Phoca CartPhoca Cart
Product Typestooltip
Simple Product
Simple Product
Product
Variable Producttooltip
Variable Product
Product Variants
Downloadable Producttooltip
Downloadable Product
Downloadable Product
Name
Name
Title
SKU
SKU
SKU
Barcode
Barcode
EAN
Tags
Tags
Tags
Manufacturer
Manufacturer
Manufacturer
Status
Status
Published
Visibility
Visibility
Access Level
Main image
Main image
Image
Gallery Images
Gallery Images
Additional Images
Alt Text
Alt Text
Alt
Position
Position
Ordering
Regular Price
Regular Price
Price
Sale Price
Sale Price
Discounted Price
Tier Price
Tier Price
Quantity Discount
Name
Name
Option
Stock per option
Stock per option
Option Quantity
Position
Position
Ordering
Variant Attributes
Variant Attributes
Option
Weight
Weight
Weight
Stock Quantity
Stock Quantity
Quantity
Status
Status
Published
Manage Inventory
Manage Inventory
Manage Stock
Stock Status
Stock Status
Availability
Backorders Allowed
Backorders Allowed
Backorders
File name
File name
File name
File URL
File URL
File
Download Limit
Download Limit
Download Limit
Download Expiry
Download Expiry
Expiry
Downloadable File
Downloadable File
Download
Name
Name
Name
Description
Description
Description
Short Description
Short Description
Short Description
Attributes
Attributes
Attributes
Meta Title
Meta Title
Meta Title
Meta Description
Meta Description
Meta Description
Meta Keywords
Meta Keywords
Meta Keywords
URL Path
URL Path
Alias
Values
Values
Values
Position
Position
Ordering
Visible On Product Page
Visible On Product Page
Published
Attribute Groups
Attribute Groups
Attribute Group
Attribute Types
Attribute Types
Field Type
Categories
Categories
Categories
Related Products
Related Products
Related Products
Brands
Brands
Manufacturers
Manufacturers
Manufacturers
Manufacturers
Category Information
Name
Name
Title
Description
Description
Description
Status
Status
Published
Meta Title
Meta Title
Meta Title
Meta Description
Meta Description
Meta Description
Parent Category
Parent Category
Parent Category
Subcategories
Subcategories
Subcategories
Sort Order
Sort Order
Ordering
Tax Rules
Tax Rule
Tax Rule
Tax Rule
Tax Class
Tax Class
Tax Class
Country
Country
Country
State
State
State
Postal Code
Postal Code
Postal Code
Rate percent
Rate percent
Rate
Shipping Taxable
Shipping Taxable
Tax Shipping
Product SKU
Product SKU
Product
Manufacturer Informationtooltip
ID
ID
ID
Name
Name
Name
Description
Description
Description
Logo Image
Logo Image
Image
Meta Title
Meta Title
Meta Title
Meta Description
Meta Description
Meta Description
Name
Name
Name
Description
Description
Description
Customer Information
First Name
First Name
First Name
Last Name
Last Name
Last Name
Email
Email
Email
Phone
Phone
Phone
Status
Status
Status
Date Created
Date Created
Created
Password
Password
Password
ID
ID
ID
First Name
First Name
First Name
Last Name
Last Name
Last Name
Company
Company
Company
Address 1
Address 1
Address
Address 2
Address 2
Address 2
City
City
City
Province
Province
State
Country
Country
Country
Zip Code
Zip Code
Zip
Phone
Phone
Phone
Address Type
Address Type
Type
Default Billing
Default Billing
Yes / No
Default Shipping
Default Shipping
Yes / No
Order ID List
Order ID List
Orders
Order Relationships
Linked Customer
Linked Customer
User ID
Linked Products
Linked Products
Products
ID
ID
ID
Number
Number
Order Number
Status
Status
Status
Currency
Currency
Currency
Subtotal
Subtotal
Subtotal
Discount
Discount
Discount
Tax
Tax
Tax
Total
Total
Total
Payment Method
Payment Method
Payment
Shipping Method
Shipping Method
Shipping
Shipping
Shipping
Shipping
Tracking
Tracking
Tracking
Note
Note
Note
Created Date
Created Date
Created
Updated Date
Updated Date
Updated
Product Name
Product Name
Product Name
SKU
SKU
SKU
Quantity
Quantity
Quantity
Unit Price
Unit Price
Price
Line Total
Line Total
Total
Tax
Tax
Tax
Discount
Discount
Discount
Options
Options
Options
First Name
First Name
First Name
Last Name
Last Name
Last Name
Company
Company
Company
Street
Street
Address
City
City
City
Province
Province
State
Country
Country
Country
Postcode
Postcode
Zip
Phone
Phone
Phone
Product Relationship
Product ID
Product ID
Product ID
Title
Title
Title
Comment
Comment
Comment
Rating
Rating
Rating
Status
Status
Status
Date
Date
Date
Customer ID
Customer ID
User ID
Email
Email
Email
Name
Name
Name
Coupon Information
Code
Code
Code
Description
Description
Description
Discount Type
Discount Type
Discount Type
Discount Value
Discount Value
Discount Value
Status
Status
Status
Start Date
Start Date
Start Date
End Date
End Date
End Date
Minimum Spend
Minimum Spend
Min Order
Maximum Spend
Maximum Spend
Max Order
Individual Use
Individual Use
Per Customer
Exclude Sale
Exclude Sale
Exclude Sale
Products
Products
Products
Excluded Products
Excluded Products
Excluded Products
Categories
Categories
Categories
Excluded Categories
Excluded Categories
Excluded Categories
Usage Limit
Usage Limit
Usage Limit
Usage Per Customer
Usage Per Customer
Usage Per Customer
Name
Name
Name
Description
Description
Description
Post Information
Title
Title
Title
Content
Content
Content
Short Description
Short Description
Short Description
Tags
Tags
Tags
URL Path
URL Path
Alias
Status
Status
Published
Visibility
Visibility
Visibility
Image
Image
Image
Images In Content
Images In Content
Images In Content
Category
Category
Category
Parent
Parent
Parent
Position
Position
Ordering
Meta Title
Meta Title
Meta Title
Meta Description
Meta Description
Meta Description
Name
Name
Name
Email
Email
Email
Comment
Comment
Comment
Date
Date
Date
Status
Status
Status
Title
Title
Title
Content
Content
Content
Short Description
Short Description
Short Description
Meta Title
Meta Title
Meta Title
Meta Description
Meta Description
Meta Description
Page Information
ID
ID
ID
Title
Title
Title
Content
Content
Content
Short Description
Short Description
Short Description
URL Path
URL Path
Alias
Status
Status
Published
Visibility
Visibility
Visibility
Template
Template
Template
Parent Page ID
Parent Page ID
Parent
Position
Position
Ordering
Created Date
Created Date
Created
Updated Date
Updated Date
Updated
Featured Image
Featured Image
Image
Images In Content
Images In Content
Images In Content
Meta Title
Meta Title
Meta Title
Meta Description
Meta Description
Meta Description
Title
Title
Title
Content
Content
Content
Excerpt
Excerpt
Excerpt
URL Path
URL Path
URL Path
Meta Title
Meta Title
Meta Title

Estimate your Migration Cost

A clear, step-by-step workflow where our technicians handle everything.

You only review the final result—we take care of the rest.
1. Service
SQL requires the Custom service.
2. Data Volume
Source Platform
SQL
Target Platform
Phoca Cart
Products
Customers
Orders
Blog posts
Custom jobs
+$100
ESTIMATED TOTAL ESTIMATED BASE PRICE
$0
Based on your selected service and data volume.
Standard Migration Source → Target
Migration Path
Source Platform ...
Target Platform ...
Data Volume
Total Data Records 0
Entity Points 0
Plan -
Service Standard Migration
0 0
icon
icon

Start your SQL to Phoca Cart Migration today!

Move your store from SQL to Phoca Cart with a secure, guided migration tailored to your business.

Start Free Demo Talk to an Expert
Banner

News and Updates

Book a personalized demo with our experts to see how your migration will work.