Skip to content
Avetti Support
Avetti Support

Getting Started

  • Getting Started Create a new Container store
  • Getting Started eShop
  • Getting Started Marketplace
  • Getting Started Multi Store Ecommerce
  • Getting Started With Accessibility
  • Getting Started With Website Performance
  • Getting Started With Google Analytics
  • Getting Started With Microsoft Clarity

Admin Pages

  • Create a New Supplier Store
  • Setup the Template/Default stores
  • Log in to a Supplier store
Dashboard
  • Dashboard
Catalog and Order Management
    Catalog
    • Product Dimensions
    • Sync Ecommerce
    • Find Products to Sell
    • Inventory
    • Prices
    • Manage Products
      • Products
      • Create Product
      • Edit Product
      • Edit Product Variations
    Orders
    • Quote Request
    • Chat
    • Return and Refunds
    • Click & Collect Orders
    • Manage Orders
About Me
  • General Information
  • Pickup Locations
  • Payment Information
Marketplace
  • Login Access Codes
  • Manage Standard Entities
  • Marketplace Category Mapping
  • Rebuild Marketplace
  • Category Profit Margin
  • Manage Supplier
  • Approve Supplier Data
  • Auction
Appendix
    Documentation Slides
    • About Me
    • Add Items – Suppliers
    • Create a Merchant Store
    • Customers
    • Manage Orders – Supplier
    • Prices – React Admin

System Admin Pages

  • Avetti Commerce Features
  • Ship Station Integration
B2C -Overview
    Templates
    • Catalog Personalization
    • Reset CDTO Cache
    • Template Skins
    People
    • Allowances
    • Customer Activity
    • Customer Properties
    • Customers
    • Member Types
    Marketing
    • A/B Split Tests
    • Add-ons
    • Basket Additions
    • Bundles
    • Coupons
    • Customer Discounts
    • Customer Segments
    • Customer Segment Prices
    • Customer Segment Ads
    • Gift Cards
    • Gift Certificates
    • Promotions
    • Sales Area Geolocation
    • Upsell/Cross-sell
    • Viral Promotions
    Settings
    • Basket Preferences
    • Image Scaling
    • Item Properties
    • Languages
    • Tax Rates
    • Order Preferences
    • Page Parameters
    • Payment Gateways
    • Retail Location
    • Search Dictionary
    • Shipping Countries
    • Shipping Packages
    • Shipping Rates
    • Sitemaps
    • Store Currencies
    • Shipping Exceptions
    • Store Preferences
    • Store Properties
    Audit Logs
    • Audit Log Views
    Catalog
    • Categories
    • Downloadable Items
    • Inventory
    • Item Reviews
    • Item Size/Weight
    • How to attach products to a category in the MCW
    • Manage Facets
    • Manage FAQs
    • Manage Galleries/PDFs
    • Manage Products
    • Multilingual Content
    • Prices
    • Validate Catalog Data
    • View Store
    • Variations
    Advanced
    • CDTO Editor
    • Change Password
    • Password Security Rules
    • Reports Configuration
    • Shopper Pwd Security
    • Site Admin Preferences
    • Solr Categories
    • Solr Items
    Media
    • Manage Media
    Orders
    • Abandon Cart
    • Customer Messages
    • Email State
    • Manage Orders
    • Manage Refunds
    • Reports
B2B - Overview
    Marketplace
      Advanced
      • Solr Items
      • Solr Categories
      • Site Admin Preferences
      • Shopper Pwd Security
      • Reports Configuration
      • Password Security Rules
      • Change Password
      • CDTO Editor
      Catalog
      • Item Status Settings
      • Item Options
      • Prices
      • Manage Facets
      • Item Size/Weight
      • Item Reviews
      • Inventory
      • Categories
      Marketing
      • Viral Promotions
      • Upsell/Cross-sell
      • Shipping Exceptions
      • Sales Area Geolocation
      • Marketing Segments
      • Gift Certificates
      • Gift Cards
      • Customer Segments
      • Customer Segment Prices
      • Customer Segment Ads
      • Customer Retargeting
      • Customer Discounts
      • Coupons
      • Bundles
      Market Place
      • Notifications
      • Master Catalog Products
      • Marketplace Suppliers
      • Marketplace Payments
      • Marketplace Categories
      • Category Profit Margin
      • Approve Products
      Media
      • Manage Media
      Order
      • Manage Refunds
      • Manage Orders
      People
      • Customers
      • Customer Properties
      Settings
      • Basket Preferences
      • Image Scaling
      • Item Properties
      • Order Preferences
      • Payment Gateways
      • Retail Location
      • Tax Rates
      • Store Preferences
      • Store Currencies
      • Shipping Countries
      Templates
      • Manage Templates
      • Reset CDTO Cache
      • Catalog Personalization
    Suppliers
      Catalog
      • Item Properties
      • Inventory
      • Manage Products
      Market Place
      • Approve Products
      • Marketplace Payments
      • Notifications
      Media
      • Manage Media
      Order
      • Customer Messages
      • Reports
      • Manage Refunds
      • Manage Orders
    MCW
      Advanced
      • Change Password
      Market Place
      • Notifications
      • Marketplace Suppliers
      • Approve Products
      Media
      • Manage Media
      Order
      • Customer Messages
      Settings
      • Store Preferences
      • Store Currencies
      • Shipping Countries
      • Item Properties
      Catalog
      • Categories
      • Inventory
      • Item Options
      • Item Reviews
      • Item Size/Weight
      • Item Status Settings
      • Prices
B2B2C - Overview
  • B2B Integration
Import and Export Files
  • Export Orders
  • Import Price and Inventory
  • Importing/Exporting Shipping Rates Spreadsheet
  • Import/Exporting SpreadSheets
  • eShop Features
Appendix
    Documentation Slides
      Others
      • Creating a Supplier Store
      • Rebuild solr
      • Publish
      People
      • Customer Data Management
      • Customers
      • Customer Properties
      Settings
      • Basket Preferences
      • Item Properties
      • MULTI-VALUED PROPERTIES
      • Retail Location
      • Shipping Countries
      • Sitemaps
      • Store Currency
      • STORE PREFERENCES
      • Store Properties
      • Tax Rates
      Advanced
      • Site Admin Preferences
      Reports
      • Business Reports
      Catalog
      • Advanced edit
      • Categories
      • Categories Spreadsheet
      • FREQUENTLY BOUGHT ITEMS
      • Import from XLS
      • Import-Export Advanced Spreadsheet
      • Inventory
      • Item Reviews
      • Manage Facets Manager
      • Simple Add
      • Prices
      • Validate Catalog Data
      • Variations
      Marketing
      • Bundles
      • Basket Additions
      • Coupons
      • Customer Discounts
      • Customer Segments
      • Gift Cards
      • Gift Certificate
      • Promotions
      • Upsell-Cross sell
      Marketplace
      • Approve Products
      Templates
      • Reset CTDO Cache
      Orders
      • Customer Messages
      • Export Orders
      • Email Settings
      • Manage Orders
      • SMS Settings
    Documentation Videos
    • Payment Gateway
    • Retail Location
    • Validate Catalog Data
    • Site Admin Preferences
    • SMS Settings
    • Advanced Edit
    • Variations
    • Manage Orders
    • Categories
    • Basket Preferences
    • Customers
    • Upsell Cross Sell
    • Allowances
    • Customer Discounts
    • Order Preferences
    • Publish
    • Rebuild Solr
    • Email Setting
    • Store Preferences
    • Item Reviews
    • Tax Rates
    • Customer Segments
    • Store Currency
    • Product Data Spreadsheet
    • Export Orders
    • Sitemaps
    • Prices
    • Coupons
    • Bundles
    • Frequently Bought Items
    • Customer Properties
    • Store Properties
    • Multi Valued Properties
    • Gift Cards
    • Promotions
    • Manage Media
    • Gift Certificates
    • Manage Facets
    • Simple Add
    • Import and Export Using Spreadsheet
    • Customer Messages
    • Creating a Supplier Store
    • Approve Products
    • Import XLS
    • Business Reports
    • Item Properties

WordPress

  • Getting Started
  • Document Checklist
  • How to create pages in Wordpress?
  • How to create New Menus?
  • How to edit the Home Page?
  • How to change Favicon and Site Title?
  • How to edit Header and Footer?
  • How to change Header and Footer?
  • How to edit Shipping Policy, Refund Policy and Privacy Policy pages?
  • How to add Google Analytics and Microsoft Clarity
  • Using Existing WP vs Using Fresh WP
  • How to change Logo URL
  • How to create Blog Posts?
  • Blog Look And Layout
  • Netlify Redirects
  • Caching Issues
  • Plugins
Plugins
  • Fluent Forms
  • Perfmatters
  • Blocksy
  • Change SEO Title and Meta Descriptions with Yoast SEO
  • Staging and Backup with WPVivid
  • Stackable
  • Custom Javascript and CSS plugin
Common Issues
  • Does Not Use Passive Listeners
  • Enable Text Compression
  • Preload Largest Content Paint Image
  • Home
  • Docs
  • System Admin Pages
  • Import and Export Files
  • Import Price and Inventory

Import Price and Inventory

Table of Contents
  • Overview 
  • Import/Export Store Data From Spreadsheet
    • Prerequisites:
      • ENTERING DATA
      • DATA DEFINITION
      • IMPORTING THE SPREADSHEET
  • Import/Export from XLS admin page
    • Prerequisites:
      • ENTERING DATA
      • DATA DEFINITION
      • IMPORTING THE SPREADSHEET
  • SUMMARY

Overview  #

Importing and Exporting Data is a fairly simple procedure. The process requires that you have privileges to access the System Administration pages, including the Import/Export subpages. It is also recommended that you have access to view and edit data at the Store Administration level for importing, as this is required to ensure the import is successful.

This manual provides information on how to import a list of prices and inventory from an XLS spreadsheet for products that have been previously created on the store.

There are 2 ways of exporting the prices and inventory to a store.

1.Using the Import/Export Store Data From Spreadsheet admin page that can be accessed from the List of Vendors page

2. Using the Import/Export from XLS admin page, which can be accessed from the store’s main menu > Catalog > Import from XLS

Import/Export Store Data From Spreadsheet #

Prerequisites: #

  • Access to the system admin pages using a Sys admin role
  • Access to the list of vendors page
  • The export orders spreadsheet that is used here is .xls format. Ensure you have spreadsheet software that can view and edit these files, such as Microsoft Excel or Open Office.

To access the Import/Export Store Data From Spreadsheet admin page, follow these steps:

1. Login to the Avetti Commerce sys admin panel and go to the List of Vendors page

2. Search for the store that needs to have the prices and inventory imported and go to the Auction column of that store.

3. Click on the ‘Import’ button (Up arrow icon)

The Import/Export Store Data From Spreadsheet admin page will open in the same window. On this page, there are several types of data you can import. This manual is directed only to importing the prices and inventory data, but the same process can be used to import other types of data such as categories and products. You may also export data from this page.

4. Find the “Import Prices and Inventory” section and click on the sample link to download a sample file that can be edited and then imported to the store.

This will download a premade .xls file to your computer that will be used as a template for importing new prices and inventory for products that have been already created.

ENTERING DATA #

5. Open the file and Enable the Edition of the file after it is finished downloading.

The Import Prices and Inventory spreadsheet contains the necessary information to update the prices and inventory of particular products in the store.

It consists of one worksheet called “PriceInventory” and the price and inventory table.

DATA DEFINITION #

The following table provides information and some examples of the values that are expected on each column:

ColumnColumn HeaderDefinition and UseAccepted ValuesExample(s)Required
AVIDThis column must have the store VID, a unique identifier for each store on the server.
If you don’t have this information, please contact your system administrator.
Numeric20230130001Yes
BProduct CodeEnter the product code per line, which is the unique identifier of the products that need to have the price and inventory updated.
This field can not be empty.
StringABC10012Yes
CCustomer CodeThe customer code column in the price inventory will map to the offer code in the offer price table.StringABC123No
DList PriceThe listed price or the manufacturer’s suggested retail price that will be used for administration purposes. This price won’t be on the product page. The List Price needs to be greater than the price. Numeric44.99Yes
EPriceThe actual price of the product that will be displayed on the category page and the product page. This is the price the shopper will pay for the product. This price needs to be lower than the List Price. Numeric23.99Yes
FCurrencyEnter on this column the currency of the order as a 3-digit code. The store currency needs to be previously set up in the store before placing an order. StringUSD / CAD / AUD / EURYes
GInventoryEnter the new inventory of the product that will overwrite the current inventory of the product. Integer100Yes

IMPORTING THE SPREADSHEET #

6. On the Import/Export Store Data From Spreadsheet admin page (follow Steps 1 to 5 to get here), click the Choose File button and navigate to your updated .xls file. Click the Open button once you have selected it.

8. Ensure the proper file has been selected by checking the value next to the Choose File button. Remember, these must be in the .xls file format.

9. Scroll down until you reach the “Upload” bottom of the Import Store Data section and click on it.

You will now see the Import/Export Task Monitor, which displays the status and other information on data I/O operations for the server. The newest tasks appear at the top of the list.

10. Wait until the status of your Import task changes from “Waiting” to “Success”. The page should automatically refresh. If it doesn’t, wait a moment and click the refresh button on your browser or press F5.

If there is any error while importing the file, go to Step 13.

11. When the status changes to “Success”, a new link will be displayed to download the file that was just uploaded.

12. Verify the price and inventory of the products were done correctly.

13. Check your errors by clicking the view link under the Action column for your task.

14. Fix the errors in the .xls file, and repeat steps 6-10 until you are successful.

Import/Export from XLS admin page #

Prerequisites: #

  • Access to the system admin pages using a Sys admin role or supplier admin role.
  • Access to editing a store
  • The export orders spreadsheet that is used here is .xls format. Ensure you have spreadsheet software that can view and edit these files, such as Microsoft Excel or Open Office.

To access the Import/Export XLS admin page, follow these steps:

1. Log in to the Avetti Commerce sysadmin panel and go to the List of Vendors page

2. Search for the store that needs to have the prices and inventory imported and click on the Store VID to access the store.

Note: If you log in as a supplier store and don’t have access to the List of Vendors page, it might be because your user has permission to access only one specific store. So you can skip steps 1 and 2. After logged in, the store’s Dashboard will be displayed:

3. Go to the main menu > Catalog > Import from XLS

The Import/Export admin page will open in the same window. On this page, there are several types of data you can import and export. This manual is directed only to importing the prices and inventory data, but the same process can be used to import other types of data such as categories and products. You may also export data from this page.

4. On the Import Store Data section, find the “Import Prices and Inventory” option from the dropdown menu and select it.

Click on the sample link to download a sample file that can be edited and then imported to the store.

This will download a premade .xls file to your computer that will be used as a template for importing new prices and inventory for products that have been already created.

ENTERING DATA #

5. Open the file and Enable the Edition of the file after it is finished downloading.

The Import Prices and Inventory spreadsheet contains the necessary information to update the prices and inventory of particular products in the store.

It consists of one worksheet called “PriceInventory” and the price and inventory table.

DATA DEFINITION #

The following table provides information and some examples of the values that are expected on each column:

ColumnColumn HeaderDefinition and UseAccepted ValuesExample(s)Required
AVIDThis column must have the store VID, a unique identifier for each store on the server.
If you don’t have this information, please contact your system administrator.
Numeric20230130001Yes
BProduct CodeEnter the product code per line, which is the unique identifier of the products that need to have the price and inventory updated.
This field can not be empty.
StringABC10012Yes
CCustomer CodeThe customer code column in the price inventory will map to the offer code in the offer price table.StringABC123No
DList PriceThe listed price or the manufacturer’s suggested retail price that will be used for administration purposes. This price won’t be on the product page. The List Price needs to be greater than the price. Numeric44.99Yes
EPriceThe actual price of the product that will be displayed on the category page and the product page. This is the price the shopper will pay for the product. This price needs to be lower than the List Price. Numeric23.99Yes
FCurrencyEnter on this column the currency of the order as a 3-digit code. The store currency needs to be previously set up in the store before placing an order. StringUSD / CAD / AUD / EURYes
GInventoryEnter the new inventory of the product that will overwrite the current inventory of the product. Integer100Yes

IMPORTING THE SPREADSHEET #

6. On the Import/Export admin page (follow Steps 1 to 5 to get here), click the Choose File button and navigate to your updated .xls file. Click the Open button once you have selected it.

8. Ensure the proper file has been selected by checking the value next to the Choose File button. Remember, these must be in the .xls file format.

9. Find the “Upload” bottom of the Import Store Data section and click on it.

You will now see the IMPORT/EXPORT STATUS Task Monitor, which displays the status and other information on data I/O operations for the server. The newest tasks appear at the top of the list.

10. Wait until the status of your Import task changes from “Waiting” to “Success”. The page should automatically refresh. If it doesn’t, wait a moment and click the refresh button on your browser or press F5.

If there is any error while importing the file, go to Step 13.

11. When the status changes to “Success”, a new link will be displayed to download the file that was just uploaded.

12. Verify the price and inventory of the products were done correctly.

13. Check your errors by clicking the view link under the Action column for your task.

14. Fix the errors in the .xls file, and repeat steps 6-10 until you are successful.

SUMMARY #

At this point, hopefully, you were successful in importing the prices and inventory. In short, the import process is as follows:

  • Navigate to the Import/Export page
  • Download the sample template file
  • Enter the necessary data for the required columns in the spreadsheet
  • Import the spreadsheet onto the store
  • Check that the data has been imported correctly
What are your Feelings
Still stuck? How can we help?

How can we help?

Updated on January 25, 2023
Export OrdersImporting/Exporting Shipping Rates Spreadsheet

Powered by BetterDocs

Table of Contents
  • Overview 
  • Import/Export Store Data From Spreadsheet
    • Prerequisites:
      • ENTERING DATA
      • DATA DEFINITION
      • IMPORTING THE SPREADSHEET
  • Import/Export from XLS admin page
    • Prerequisites:
      • ENTERING DATA
      • DATA DEFINITION
      • IMPORTING THE SPREADSHEET
  • SUMMARY

Copyright © 2022 Avetti.com Corporation.