•  914-288-5685
  •   sales@revindex.com
   Search
FR
0
 
  • Register
 
Login
Revindex
  • Products
    • -Comodo PCI Scan
    • -RapidSSL Certificate
    • -RapidSSL Wildcard Certificate
    • -Revindex Generic Skin
    • -Revindex Impersonator
    • -Revindex Omni Skin
    • -Revindex Optimizer
    • -Revindex Polo Skin
    • -Revindex Priority Support
    • -Revindex Storefront
    • -Revindex Storefront Service Plan
    • -Revindex Storefront Source
    • -Revindex Storefront Source Service Plan
    • -Revindex Task Scheduler
    • -Revindex Wiki
    • -Software License Modification
  • Services
    • -Design
    • -Programming
    • -Hosting
    • -Merchant Account
  • Resources
    • -Downloads
    • -Knowledge Base
      • --ASCII Characters
      • --HTML Entities
      • --Revindex Impersonator
      • --Revindex Optimizer
      • --Revindex Storefront
      • --Revindex Task Scheduler
      • --Revindex Wiki
      • --Standard DNN Tokens
    • -Tools
      • --Remote Ping
      • --Unit Converter
      • --URL Encoder Decoder
      • --HTML Encoder Decoder
      • --GUID Generator
    • -Blogs
  • Support
    • -Forum
    • -Frequently Asked Questions
    • -Support Ticket
  • Company
    • -About Us
    • -Customer Portfolio
    • -Customer Reviews
    • -Resellers
  • Free Trial
You are here: Resources ⁄ Knowledge Base ⁄ Revindex Storefront

Revindex Storefront

Email Export Print

Overview

The import procedure accepts delimited data files (CSV delimited using either a comma, pipe, tab or semicolon) that matches the specification in the map file. The first row must contain the header row with the column names. The actual column ordering may vary. It’s recommended to enclose all column data in double quotes (e.g. "Apple iPad" or "149.99") to escape any delimiter characters present in the text.

CSV files are processed row by row from top to bottom. For new insertions, if you have any parent child dependency, you should ensure the parent's row appears before the child's row. The row sequence is not needed for updates or deletes. For example, the "Laptop" category has a parent category called "Computers". If you're inserting both categories at once, the "Computers" row should appear before the "Laptop" row. Similarly, you cannot insert product variants if the product does not yet exist since product variant has a dependency on the product.

Map File

The import routine uses a mapping file to determine the delimiter character and map the actual property name with your column name. In addition, the mapping file can accept default values for insertions. The map file is a simple XML that you can edit to suit your purpose.

<map delimiter=",">
   <prop name="Act" col="Act" default="u" />
   <prop name="ProductID" col="ProductID" />
   <prop name="Published" col="Published" default="True" />
   ...
</map>

You should not delete any lines from the map file. Instead you can modify the attribute values according to the notes below:

  • The delimiter attribute specifies the character delimiter to use. This should be a single character normally a comma, semi-colon, pipe or tab. 
  • The name attribute is the entity property name and should not be changed.
  • The col attribute should match your actual column name in your CSV file.
  • The default value is the value that should be used for insertion if the data column is not present in your CSV file.

Action

The actual type of operation performed by the import routine depends on the action specified in the Act column (Insert, Update, Delete). If the Act column is not provided, the system will use the default action specified in the map file. In your CSV file, you can have a few rows that insert, followed by other rows that update or delete as long as those actions are allowed by that entity type. See each entity type for the available actions.

Columns

Most of the columns map directly to the same fields you find the Storefront admin interface. Therefore, it's good idea to start by creating a few sample entries in your Storefront to understand how the data is being used and export out the file to see what the actual data looks like

For insert actions, your import file should include all the columns. If a column is not provided, it will use the default value in the map file, if available.

For update actions, you need to provide the object identifier or the object key if available. If a data column is not provided, the property value of the object in question will be unchanged where it makes sense.

For delete actions, you need to provide the object identifier or the object key if available.

Object Identifier and Keys

When inserting new data, you can leave the database object identifier blank (e.g. ProductID) as it will be automatically generated by your database. However, when you perform an update or delete action, you need to make sure the database object identifier or key is specified. It is good practice to always export and use the latest data before updating because the data may have changed by another user from the Storefront adminstration page or automatically changed by the system (e.g. the product variant inventory count may have decreased from customer purchases).

Object keys are available for many entities such as category, product, manufacturer, etc. that you can use in place of object identifiers to reference related objects by their unique key rather than with the database generated object identifier. For example, you can name your product key "apple-ipad" to make it easier to recall when you need import product categories rather than referencing by its identifier number "831". To display the object keys in the merchant interface, you must first enable the Show object key feature under Configuration > General.

Language Localization

If your site operates in multiple languages, the data exported out or being imported into depends on the currently viewed page language. For example, if you're browsing your site in English (United States), any localizable string value in the CSV file will be treated in the en-US locale. If you later switch over to French (France), any localizable string value in the CSV file will be treated in the fr-FR locale.

Validating Errors

During import, when possible, the Storefront will perform a series of validation row by row and will automatically rollback the entire data changes if any incorrect data is detected to protect the integrity of your system. Even with the automatic validation and transaction rollback, we still recommend that you perform a complete backup of your system before performing any import.

Limitations

Please note that Web applications are limited by network, CPU and allowed memory consumption. When importing large amount of data, it is recommended to run multiple smaller imports (e.g. import 10,000 records at a time instead of 100,000 records at once).

Google Spreadsheets

We recommend using Google sheets to edit your CSV file. It's free and is hosted online with nothing to install. Once you're done editing, you can download it back as CSV file.

  1. Start a blank spreadsheet.
  2. Click on File > Import.
  3. Choose the Upload tab and select the file from your computer.
  4. Set the Separator character = comma
  5. Set the Convert text to numbers and date = No
  6. Click Import.

Microsoft Excel

In most cases, you can simply double click the CSV file you exported to open it in Excel for editing. Please note, however, that Excel by default will attempt to convert numbers into its own native format. This may present a problem for fields like SKU that is normally a text field. For example, if your SKU values consist of only long numbers such as "12231231243", Excel will convert it to a number format and it will end up showing on your screen as "1.22E+10". The proper way to open a CSV file is to start with a blank Excel spreadsheet and perform a data import. 

  1. Open a new blank spreadsheet.
  2. Under the Excel's Data tab, click on the From Text button
  3. Select your CSV file to import
  4. Choose Delimited file type and Start Import at row = 1 and File origin = Unicode (UTF-8). Click Next.
  5. Select Comma as your only delimiter (deselect other delimiter types) and Text qualifier = " (double-quote) and click Next.
  6. In the Data preview, use the SHIFT key to select all columns and set the Column data format = Text.
  7. Click Finish on the next screen.
  8. Place the imported data on your first cell.

Comments

Add comment
Previous Next

Search

Search

Contents

  • Users Manual
    • Overview
    • Installation
      • Requirements
      • How to install
      • Quick start settings
      • License key
      • Common installation errors
      • Adding module controls
      • How module controls interact
      • How to move modules
      • How to SSL secure your pages
      • How to improve performance
      • How to upgrade
      • How to install DNN on local machine
      • Web farm
      • How to uninstall
      • How to re-install with data
      • How to migrate product data
    • Administration
      • Configuration
        • General
        • Currencies
        • Payment
          • Gateways
            • Authorize.Net AIM
            • Authorize.Net CIM
            • Authorize.Net SIM
            • Barclaycard DirectLink
            • BluePay
            • Cardstream Direct
            • CashFlows Remote API
            • Chase Paymentech Orbital Gateway
            • Corduro
            • CyberSource
            • Dotpay
            • Elavon Virtual Merchant
            • eProcessing Network
            • eWay Direct Payment Australia
            • FirstData Global Gateway Web Service
            • FTNI
            • FTNI ACH
            • InternetSecure
            • Intuit QuickBooks Merchant Service
            • MasterCard Internet Gateway Service Hosted
            • Merchant e-Solutions
            • Mollie
            • Moneris eSelectPlus Canada
            • NMI
            • PayFast Website Payment
            • Payment Express PxPay
            • Payment Express PxPost
            • PayPal Express Checkout
            • PayPal Payment Gateway
            • PayPal Payments Standard
            • PayPal Website Payments Pro
            • Paystation 3-Party
            • PayTrace
            • PayU Business
            • PayU Enterprise
            • Peach Payments
            • Princeton CardConnect
            • PSiGate XML Messenger
            • Sage Pay Direct
            • Sage Pay Form
            • Sage Payments Direct
            • Stripe
            • Suomen Verkkomaksut
            • Total Apps
            • Towah
            • USA ePay
            • Virtual Card Services Pay
            • WorldPay Corporate XML Direct
            • Zooz
            • Custom gateway
          • How to offer free products without payment
          • How to avoid duplicate order number error
        • Taxes
          • Providers
            • Avalara
            • TaxJar
            • Zip2Tax
          • How to use a tax table
        • Packages
        • Packing
          • Single package
          • Single product
          • Volume fit
        • Shipping
          • Shipping Availability
          • Shipping Rate
          • Providers
            • ABF
            • Australia Post
            • Canada Post
            • CouriersPlease
            • DHL Express
            • FedEx
            • Purolator
            • Shipwire
            • Southeastern
            • Unishippers
            • UPS
            • USPS
          • How to configure real-time shipping
        • Fulfillment
          • ShipWorks
        • Handling
          • How to charge handling for payment type
        • Communications
          • Cart abandon email
          • Order alert email
          • Order invoice email
          • Order invoice print
          • Order quote email
          • Order quote print
          • Order receipt email
          • Order receipt print
          • Order update email
          • Packing slip print
          • Payment alert email
          • Recurring order payment retry email
          • Recurring order reminder email
          • Right receipt email
          • Voucher receipt email
          • How to troubleshoot email not receiving
          • How to make HTML editor behave
        • Reports
          • How to create custom reports
          • How to export data from custom report
        • Rewards points
        • Analytics
        • Sitemap
        • Affiliates
        • Address validation
          • Avalara
        • Fraud risk
          • FraudLabs Pro
          • Sift Science
        • Channels
          • eBay
        • Accounting
          • QuickBooks
          • Xero
      • Catalog
        • Categories
          • Category availability
        • Distributors
        • Manufacturers
        • Warehouses
        • Product attributes
          • Groups
          • Definitions
        • Products
          • Attributes
          • Gallery Images
          • SEO
          • Product Availability
          • Custom fields
          • Variant groups
          • Variants
            • Inventory
            • Warehouse
            • Price
            • Product Modifier
            • Product Promotion
            • Subscription Products
            • Taxable Products
            • Weight & Dimensions
            • Variant Availability
            • Attributes
            • Gallery Images
            • Quoted products
            • Bundled products
            • Booking products
            • Required Products
            • Downloadable Products
            • Custom fields
            • Actions
            • Extensions
          • Cross-sell products
          • How to create a simple product
          • How to create a recurring product
          • How to create a setup fee
          • How to create overridable price product
          • How to create a configurable price product
          • How to create downloadable products
          • How to create a catalog product
          • How to create a voucher product
          • How to email external license key
          • How to show product without category
          • How to give first month recurring free
          • How to create a deferred product
          • How to sell on eBay
          • How advanced URL provider works
          • How to delete all products
        • Vouchers
        • Rights
      • Sales
        • Orders
          • Order, Payment & Shipping Status
          • Payments
            • How to refund payment
          • Preorders
          • How to accept offline orders
          • Why do order numbers skip?
          • How to auto delete incomplete orders
          • How to delete all orders
        • Recurring Orders
        • Bookings
        • Rights
        • Vouchers
      • Marketing
        • Coupons
          • Coupon Availability
        • Promotions
          • Handling Type Promotion
          • Product Type Promotion
          • Sales Order Detail Type Promotion
          • Shipping Type Promotion
          • Tax Type Promotion
      • Access Control
      • Log Level
    • Category
      • How to expand all categories
      • How to add categories to Web site menu
    • Distributor
    • Manufacturer
    • Product List
      • Hosting Multiple Module Controls
      • How to change default sort order
      • How to change the number of grid columns
      • How to change page size
      • How to default to list view
      • How to force products from a category
      • How to show featured products
    • Product Detail
      • Hosting Multiple Module Controls
      • How to force product
      • How to set number of related products
    • Product Filter
    • Product Search
      • How search works
    • Product Showcase
    • Product Comparison
    • Cart Summary
      • How to change payment acceptance mark
    • Cart
      • How to increase cart session time
      • How to cleanup on logout
    • Checkout
      • Anonymous Checkout
      • Multiple step or single page checkout
      • Checkout Availability
      • Actions
      • How to assign security role on checkout
      • How to change payment acceptance mark
      • How to hide unwanted country
      • How to set default country
      • How to include registration form in checkout
      • How to create a single login & register page
      • How numbers are calculated and rounded
      • How to require terms & agreement
    • Confirmation
    • Currency
    • Quick Order
    • Wish List
    • Manage Address
    • Manage Product Download
    • Manage Order
    • Manage Payment
    • Manage Recurring Order
    • Manage Rewards Points
    • Manage Rights
    • Manage Vouchers
    • Manage Wish List
    • Multi-seller marketplace
      • Sellers
      • Administration
      • Order splitting
    • Text and languages
      • International languages
      • Static Localization and Language Packs
        • How to format the currency symbol
        • How to create your own language pack
        • How to format page title
      • Content Localization
        • How to localize XSL email template
    • Design and Styling
      • Display Templates
        • Understanding CSS Precedence
        • How to override CSS styles
        • How to style buttons
        • How to upgrade display templates
        • How to edit template in Visual Studio
        • How to expand panel by default
        • Removing unwanted elements
        • Styling Telerik controls
      • Models
        • CartModel
        • CartSummaryViewModel
        • CartViewModel
        • CategoryModel
        • CategoryViewModel
        • CheckoutModel
        • CheckoutViewModel
        • CodeType
        • ConfirmationModel
        • ConfirmationViewModel
        • CrosssellProductModel
        • CrosssellProductViewModel
        • DistributorFilterModel
        • DistributorModel
        • DistributorViewModel
        • DynamicFormCodeModel
        • DynamicFormFieldModel
        • DynamicFormModel
        • GalleryFormatType
        • GalleryModel
        • IntervalType
        • InventoryUnitType
        • LoginModel
        • ManageWishListModel
        • ManufacturerFilterModel
        • ManufacturerModel
        • ManufacturerViewModel
        • PagerModel
        • PaymentMethodModel
        • PaymentMethodType
        • PriceFilterModel
        • ProductAttributeDefinitionModel
        • ProductAttributeDefinitionSelectionModel
        • ProductAttributeFilterModel
        • ProductAttributeGroupModel
        • ProductAttributeModel
        • ProductAttributeType
        • ProductComparisonModel
        • ProductComparisonViewModel
        • ProductComponentModel
        • ProductComponentType
        • ProductDetailModel
        • ProductDetailViewModel
        • ProductFilterModel
        • ProductFilterViewModel
        • ProductInventoryEmptyBehaviorType
        • ProductListModel
        • ProductListPageViewDisplayOrderType
        • ProductListViewModel
        • ProductModel
        • ProductPartModel
        • ProductReviewModel
        • ProductReviewViewModel
        • ProductSearchViewModel
        • ProductShowcaseDisplayEffectType
        • ProductShowcaseScrollDirectionType
        • ProductShowcaseViewModel
        • ProductVariantGroupFieldType
        • ProductVariantGroupModel
        • ProductVariantGroupOptionModel
        • ProductVariantModel
        • RecurringIntervalType
        • RegistrationModel
        • RequiredProductModel
        • SalesOrderDetailModel
        • SalesOrderDetailStatusType
        • SalesOrderModel
        • SalesOrderSetModel
        • SalesPaymentModel
        • SalesType
        • SellerModel
        • ShoppingModel
        • UserAddressModel
        • UserModel
        • UserPaymentModel
        • ValidationResultModel
        • WishListModel
        • WishListType
        • WishListViewModel
    • Shopping Cart Flow
      • Customer initiates checkout
      • Merchant fulfills new order
      • Merchant cancels bad order
      • Merchant fulfills recurring order
      • Understanding payment risk
      • How to force order and payment status
    • Page action
      • Examples
    • Import and Export
      • Overview
      • Data Types
      • Entities
        • Category
        • Distributor
        • Gallery
        • Manufacturer
        • Product
        • Product Attribute
        • Product Attribute Definition
        • Product Attribute Group
        • Product Category
        • Product Component
        • Product Part
        • Product Review
        • Product Variant
        • Product Variant Group
        • Product Variant Group Option
        • Product Variant Option
        • Recurring Sales Order
        • Related Product
        • Required Product
        • Right
        • Sales Order
        • Sales Order Detail
        • Similar Product
        • Voucher
        • Warehouse
      • Examples
        • Export products
        • Insert products
        • Update products
        • Delete products
        • Export products (SQL)
        • Export orders (SQL)
        • How to bulk update gallery images
        • How to bulk update product keys
      • Site Wide Import and Export
    • REST API
      • Overview
      • Data Types
      • Authentication
      • Services
        • Category
        • Coupon
        • CrosssellProduct
        • Distributor
        • Gallery
        • Locale
        • Manufacturer
        • Portal
        • Product
        • ProductAttribute
        • ProductAttributeDefinition
        • ProductAttributeGroup
        • ProductCategory
        • ProductComponent
        • ProductPart
        • ProductVariant
        • ProductVariantGroup
        • ProductVariantGroupOption
        • ProductVariantOption
        • RecurringSalesOrder
        • RelatedProduct
        • RequiredProduct
        • Right
        • RightDefinition
        • SalesOrder
        • SalesOrderDetail
        • SalesPayment
        • SalesPromotion
        • ShippingMethod
        • TaxClass
        • User
        • UserPayment
        • Voucher
        • VoucherDefinition
        • Warehouse
      • Examples
        • Export order (Powershell)
        • Export order 2 (Powershell)
        • Export products (Powershell)
        • QuickBooks export customer (Powershell)
        • QuickBooks export sales order (Powershell)
        • Shipwire export order (Powershell)
        • Retrieve product (C#)
        • CSV bulk import
    • XML and XSL
      • XSL Transform
      • XSL Tokens
      • Debugging XSL
    • String Tokens
    • Lookup Values
      • Account Types
      • Country and Subdivision Codes
      • Inventory Unit Types
      • Package Types
      • Payment Gateway Response Codes
      • Payment Gateway AVS Response Codes
      • Payment Gateway CVV Response Codes
      • Payment Method Types
      • Payment Origin Types
      • Payment Term Types
      • Recurring Interval Types
      • Recurring Sales Order Status Types
      • Rewards Points Operation Types
      • Rewards Points Status Types
      • Sales Order Detail Status Types
      • Sales Order Origin Types
      • Sales Types
      • Sales Order Status Types
      • Sales Payment Status Types
      • Sales Payment Transaction Types
      • Shipping Status Types
      • Voucher Interval Types
      • Voucher Status Types
    • Compliances
      • GDPR
      • PCI
  • Release notes

Powered by Revindex Wiki

Copyright Revindex Inc. : Terms Of Use : Privacy Statement
Copyright Revindex Inc. : Terms Of Use : Privacy Statement