J2Commerce Documentation
DownloadExtensions
  • Welcome to J2Commerce
  • Getting Started
    • Introduction to J2Commerce
    • Getting started with J2Commerce
    • Technical Requirements
    • Installation
    • Update
    • Upgrade from FREE version to PRO version of J2Commerce
  • Migrating from J2Store 3 to 4 3 to 4
  • Set up
    • Content plugin settings
    • Configuration
    • Currency
    • Custom fields
    • Set up multi-currency
  • Quickstart guide
  • Product Types
    • Simple product
    • Variable product
    • Configurable product
    • Flexible variable product
    • Downloadable product
  • Layout
    • Products List View
    • Products Tag View
    • Usecases
    • Category Tree for displaying filters
    • Special module positions
  • Catalog
    • Assigning a product to multiple categories
    • Product Description
    • Short codes
    • Adding specifications to your products
    • Advanced Pricing
    • Setting up tax for your products
    • Options
      • Import product options
      • How to create options and add them to your products
    • Filters
      • Product filters
      • Translating filters to your language
    • Manufacturers
    • Vendors
    • Adding related products
    • Ordering products on your storefront
  • Subscriptions and Memberships
    • Introduction to subscriptions and memberships in J2Commerce
    • Quickstart
    • Requirements and Installation
    • Basic Settings
    • Creating subscription based products
    • Simple Subscription Product
    • Paypal Reference Transactions for Subscriptions
    • Usecases
    • Customizing the subscription mail templates
    • Frequently Asked Questions
  • Partial Payments
    • Introduction to Partial payments
    • Basic Settings
    • Setting up plans for Partial Payments
    • Instances
    • Usecases
  • Booking and Reservations
    • Limitation of the booking products type
    • Requirements and Installation
    • Basic settings and Booking Management
    • Booking and Reservations
    • Creating a Bookable Product
    • how to restrict multiple booking for a product person based restriction
    • Usecases
  • Localisation
  • Translation
    • Translate J2Commerce into your language
    • Setting up the store in your Language
    • How to write language override for plugin in multilingual site
    • Language overrides in Joomla with examples
    • Translating Product Options
  • Design
    • Email templates
    • Invoice Template (Pro Feature)
  • Tax configuration
    • Untitled
    • Recommended Tax configuration for US States
    • Recommended Tax configuration for Canadian Stores
    • Recommended Tax Configuration for EU stores
    • Setting up European VAT Rules for selling Physical Goods with J2store
    • A simplified guide for New EU VAT rules 2015 for digital goods and setting them up in J2Store
    • How Tax is Calculated
  • Easy Checkout
    • Easy checkout
    • Trouble shooting issues
  • Shipping methods
    • Free Shipping
      • How to create coupons for free shipping
    • How to set up local store pick up shipping method
    • Australia post shipping plugin
    • Bring shipping plugin
    • Canadapost shipping plugin
    • FedEx shipping plugin
    • Purolator
    • Postal Code shipping plugin
    • Royal Mail Shipping
    • Standard shipping methods
    • Table Rate Shipping
    • UPS Shipping
    • USPS Shipping
    • United States postal service Shipping Plugin
    • USPS Advanced
  • Payment Methods
    • AliPay Payment Plugin
    • Authorize.Net plugin
    • Bank Transfer
    • Barclays Payment plugin
    • Braintree payment plugin
    • Cash on Delivery
    • CardSave Payment plugin
    • CCAvenue payment plugin
    • CECA Payment
    • Checkout fi¨
    • Culqi Payment
    • DIBS payment plugin
    • Direcpay Payment Plugin
    • EBS Payment Plugin
    • Elavon Coverage/Virtual Merchant Payment Plugin
    • eway Payment Gateway for j2store
    • First Data Plugin
    • Flo2Cash for J2Store
    • GestPay
    • Heartland Payment Plugin
    • Icepay Payment Plugin
    • Interpay
    • Klarna Payment Plugin
    • Mollie payment plugin
    • Money Order
    • Moneris eselectplus Hosted Paypage
    • MultiSafe Payment Plugin
    • Nochex Payment Plugin
    • NMI Payment Gateway
    • Ogone Payment plugin
    • Pagseguro Payment plugin
    • Paybox Payment plugin
    • Payeezy
    • Payfast Payment plugin
    • Paygate Payment
    • Paymate
    • Paypal Sandbox
    • Paypal Adavnced Payment plugin
    • Payment Express for J2Store
    • Payment Sense
    • Paypal Express Checkout
    • Paypal payment plugin
    • Paypal Pro Payment Plugin
    • Payseal Payment Plugin
    • Paysera Payment Plugin
    • Payson Payment Plugin
    • Payson Invoice Payment Plugin
    • Pay U Latam
    • PayUMoney plugin
    • Poli Payment Plugin
    • Post Finance
    • QuickPay
    • Razorpay
    • Rabobank Omnikassa
    • RealEx Payment Plugin
    • Redsys/Servired/Sermepa Payment Plugin
    • Sagepay Form Payment Plugin
    • Secure Trading Plugin
    • Sepa Payment
    • Sisow Payment for J2Store
    • Skrill Payment Plugin
    • Sofort Banking
    • Stripe
    • Squareup Payments
    • Tranzila Payment Plugin
    • USAePay Payment Plugin
    • Voguepay Payment Plugin
    • Worldpay Payment Plugin
    • 2Checkout Plugin
  • Sales
    • Coupons
    • Vouchers
    • Customers
    • Orders
  • Report Sales
  • Modules
    • Product search module
    • J2store Detailed Cart
    • Product categories module
    • Product display module
  • Apps
    • Add to user group
    • Additional fee
    • Ask question / quote
    • Availability-notification
    • Bundled Products
    • Bulk discounts
    • Change Password
    • Checkout Redirect
    • Custom Tabs
    • Data validation
    • Donation
    • Drop-box
    • Email basket Plugin
      • Email basket issues
    • GDPR compliance
    • Google-analytics-ecommerce-tracking
    • Group Products
    • How to send download links through email notifications
    • Image Popup
    • Invoice Prefix Generator
    • Open hours (time based restriction)
    • Pay later/Pay against invoice
    • Points and Rewards
    • Re-Order
    • Shipstation
    • Simple CSV import and export tool
    • Tax Utilities
    • Upload file in checkout
    • Quantity dropdown
  • Frequently Asked Questions
    • Where can i find my sub-template
    • Products not aligned properly on list view
    • SCA support for payment plugins
    • To show the base price instead of price range in flexivariable products
    • Where do I add the CSS on my site
    • Unable to save the settings in any app
    • Difference between product types
    • Commonly found issues
    • Frequently Asked Questions
    • Quantity Restriction
  • Troubleshooting Guide
    • Products not visible on storefront
    • Cart not Working
    • Troubleshooting Cart related Issues
    • Moving the description
    • Troubleshooting Checkout Issues
    • Troubleshooting Common Issues
    • How to disable shipping address and payment in checkout
    • Joomla Article Error decoding json data
    • Troubleshooting Email Issues
    • Troubleshooting Paypal related Issues
    • Troubleshooting Product Display Module Issues
    • How to create a custom thank you message
    • Troubleshooting Shipping Issues
    • Troubleshooting Tax Issues
    • Troubleshooting Translate related Issues
  • Common Overrides
    • To add options to downloadable products
    • Moving additional image list to the left of the main image in product view page
    • To display the UPCE/BAN/ISBN on the product page
    • To Display Both the main Image and the additional image in the product view page
  • Video Tutorials
    • Quick Start
    • Catalog Management
    • Subscriptions
    • Booking and Reservation
    • Partial Payments
    • Tax
    • Shipping Methods
    • Discounts
    • Language
    • Apps
    • Email and Invoice Template
    • Checkout and Payment
    • Sales and Orders
    • J2Store CPanel
  • General
    • How to set cron job on your server
    • How to create an FTP account and super user account in Joomla
  • Developer Guide
    • Introduction
    • Queue System
    • App for J2store
    • Sub-templates
    • Creating an integration plugin for your component
    • Payment plugin
    • Templates
  • Canonical URL Plugin
Powered by GitBook
On this page
  • Important instructions before using this app
  • Limitations
  • Parameters
  1. Apps

Simple CSV import and export tool

Important instructions before using this app

  1. Backup your site -Before you tend to use this app for import / export operations, you MUST be careful enough to take a full backup of your site. Use Akeeba backup to take the backup.

  2. Export once -Export your products into .csv format once, to see how the format looks like. Check for field names. They should match.

  3. Importing New Products -If you want to import new products, then you can ignore the product_id field. And just make sure your products have a unique SKU. If an existing product has the same SKU as your new product, then the app will only update the existing product instead of creating a new one.

  4. Unique SKU of the products MUST be unique. If there is a duplicate, it will result in an error.The app depends on SKU to find a product. So, if an SKU is found when searched, the existing product will be updated with the imported product details. If a match is not found, a new product will be created with the SKU.

  5. Support for importing product options and / or product variants are not available.

Limitations

Please note that the Simple CSV app does not support exporting of the Variable products, although you can import data like price after you created the variants manually

  • It only supports Joomla articles as products. It DOES NOT support other catalog sources like K2, Zoo etc.

  • Product options, categories cannot be imported.

  • Support for importing product options and / or product variants are not available.

  • It only supports the importing of the product data.

Parameters

  1. Choose Import Type -You can choose to upload a CSV file or point the app to locate the file in a path. Recommended setting is: Upload.

  2. Upload the CSV file -Click on the Browse button to select the CSV file for uploading.

  3. Character Set -If you are not sure about the charter set of your file or do know what it is, then it is safe to leave it as Not Known. The app will attempt to determine the character set.

  4. Update product if SKU already exists -If set to Yes, it will update existing products, if the SKU matches. Setting this to NO will only create new products.

  5. Export Products -Clicking this button will export your products in csv format.

The following image illustrates the actions that are involved in import and export of .csv file.

A sample .csv file is given here for your testing purposes.

Below is a list of fields that are supported by the app for importing.

It is NOT necessary to have all these fields in your CSV. The following fields are the minimum required fields: sku, product_type

  • sku

  • product_id

  • visibility

  • product_source

  • product_source_id

  • product_type

  • taxprofile_id

  • manufacturer_id

  • vendor_id

  • has_options

  • addtocart_text

  • enabled

  • plugins

  • params

  • created_on

  • created_by

  • modified_on

  • modified_by

  • up_sells

  • cross_sells

  • main_image

  • thumb_image

  • additional_images

  • title

  • alias

  • introtext

  • fulltext

  • state

  • catid

  • created

  • created_by_alias

  • modified

  • checked_out

  • checked_out_time

  • publish_up

  • publish_down

  • version

  • ordering

  • metakey

  • metadesc

  • access

  • hits

  • metadata

  • featured

  • language

  • xreference

  • is_master

  • upc

  • price

  • shipping

  • length

  • width

  • height

  • length_class_id

  • weight

  • weight_class_id

  • manage_stock

  • quantity_restriction

  • min_out_qty

  • use_store_config_min_out_qty

  • min_sale_qty

  • use_store_config_min_sale_qty

  • max_sale_qty

  • use_store_config_max_sale_qty

  • notify_qty

  • use_store_config_notify_qty

  • availability

  • allow_backorder

  • isdefault_variant

  • quantity

TIPS

If you want to import more than one additional images (in the additional_images field), you can use a pipe symbol (|) to separate them.

Example: path/to/image1.jpg | path/to/image2.jpg

PreviousShipstationNextTax Utilities

Last updated 6 months ago

Simple CSV