Prestashop products import

Contents

How to work with PSQQQ


Step 1. Create a new account. It will take 2 minutes and you will get your login/password for your private area at PSQQQ.

Step 2. You can test and ask questions to support for FREE during 14 days! Login into PSQQQ. Support will help you to solve all your issues with the PSQQQ.

Step 3. Import products into PSQQQ. Read manual or contact support team with your questions - it is FREE.

Step 4. If any issue - create a ticket in the App for Support.
Import products CSV files into your Prestashop store!


PSQQQ allows you to do full automation for products import / update and sync from any CSV products files for your Prestashop stores.
You can import any size of files: we tested that on 10GB size CSV.

How it works

1. You import products CSV AS IS to PSQQQ as supplier products without any changes.
2. You define margin rules for repricing.
3. You select all products or any subset of supplier's categories / products what you want to import to Prestashop.
4. PSQQQ updates selected products with new prices at MainFEED.
5. Your MainFEED you can export to your Prestashop store via API or direct SQL db calls or you can access data via API.
Products fields for CSV Prestashop import
- SKU,ID,MPN,UPC,BARCODE,Ref etc,
- Price, SalePrice, OldPrice, Discount,
- Quantity/Stocks/Availability,
- Name,
- Categories,
- Manufacturer,
- Features,
- Options,Variants (Colors,Sizes etc),
- Dimensions: L x W x H, and Weight,
- Description,
- Images ,
- Url.




Import CSV files into your Prestashop store via psqqq.com


PSQQQ allows you to do full automation for products update and sync from any CSV files for your Prestashop stores.
You can add new suppliers CSV files itself or to ask us to do that for you by request.

Find below how it looks inside our software for Prestashop.

       

Step 1 – Feed configuration for Prestashop CSV import


There are several options exist how to upload CSV file
— from PC
— from URL, FTP, Dropbox, Google sheets etc.
— from Email
— sometimes it is necessary to download file from supplier website under client's login & password (it is possible but will require custom development)
 

Video instructions – creating a supplier's feed and uploading a file

 

Step 2 – CSV format selection during CSV Prestashop import


— by default, the system does not know the format of file you defined,
— clever algorithm tries to detect format itself (in your case CSV file) for Prestashop
— if you see any issue with format detection, you can set the right variant manually
   

Step 3 – Encoding for CSV, delimiter and wrapper before CSV import into Prestashop


— there are many ways how CSV file can be saved
— software has to be ready to open common variants of CSV file for Prestashop
— clever algorithm tries to detect all options automatically
— at this image, you see detection result for specific file
— client can change options if you see issues manually
   

Video instructions – encoding for CSV, delimiter and wrapper before CSV import into Prestashop

 

Step 4 – Columns definition for CSV file


— each file for Prestashop import has columns
— user has to define what column contains names, what column contains prices. It is columns matching
— there are 2 ways how to do that for CSV file at PSQQQ
1) via column definition
2) via product model fields definition(advanced mode – extended settings)
 

Step 4.1 — Loading categories

1) If the categories and subcategories are located in different columns, then to load them, you need to define the name of the columns as Category1, Category2, etc.

2) If the categories and subcategories are located in the same cell, then we define the column name as CategoryMultivalued. Then go to the Extended Settings in the Categories tab, in the CategoryDelimiter line, enter the separator between the category and the subcategory. In my example, this is a slash.

   

Video instructions – Loading categories

 

Step 4.2 — Loading basic product data

Basic information about the product – SKU, Name (required fields for downloading), Price, Quantity, etc. To load them, you need to correctly match the column names.

 

Video instructions – Loading basic product data

 

Step 4.3 — Uploading images

1) If the links to the images are located in separate columns, then you need to define the name for each column as “Image 1 (URL)”

2) If all links to images are located in one column in one cell, we define the column name as “Image1 (URL)”. Next, go to the Extended Settings → Images tab, in the "ImagesDelimiter" line, enter the separator between the images.

   

Video instructions – Uploading images

 

Step 4.4 — Loading features

1)Bulk loading of features. If the columns with features in the file go one after the other, then for the first column with the feature, we define the name as "FeatureFirst", the names and values of the remaining columns will be loaded automatically.

2) If the columns with features are out of order in the file, then the columns with features are defined as "Feature1", "Feature2" and so on. And enter the name of the feature in the "FeatureName" lines in the Extended Settings in the Features tab.

   

Video instructions – Loading features

Step 4.5 — Loading products with variants

1)To load products with variants, there must be a column with an SKU in the file that will combine all the variants (we define it as an SKU) and for each variant a column with its own unique SKU (we define the column as a CombinationSku). In the Extended Settings → the Combinations tab, we enter from which columns to take values for Price, Quantity, Image, etc.

2)Be sure to download the options variants — this is what distinguishes one product variant from another, for example, it may be the size or color of the product. To do this, we define columns with options as "Combination. Option1", "Combination. Option2”, etc., and in the Extended settings → the Combinations tab, in the "OptionName" lines, enter the name of the options.

 

Video instructions – Loading products with variants

 

Import XML files into your Prestashop store!


PSQQQ allows you to do full automation for products update and sync from any XML files for your Prestashop stores.
You can add new suppliers XML files itself or to ask us to do that for you by request.

Find below how it looks inside our software for Prestashop

 

Step 1 – Feed configuration


There are several options exist how to upload XML file
— from PC
— from URL, FTP, Dropbox, Google sheets etc.
— from Email
— sometimes it is necessary to download file from supplier website under client's login & password (it is possible but will require custom development)
 

Video instructions - creating a supplier's feed and uploading a file

 

Step 2 – XML format selection


— by default, the system does not know the format of file you defined,
— clever algorithm tries to detect format itself (in your case XML file) for Prestashop
— if you see any issue with format detection, you can set the right variant manually

Step 3 — XML tags definition for XML file


— each XML file for Prestashop import has tags

— user has to define what XML contains names, what column contains prices. It is columns matching
— there are 2 ways how to do that for XML file at PSQQQ
1) via tags definition

Step 4 — Define XPath for required fields of your XML file

A standard XML file consists of two blocks: a block with categories and a block with a product card. A block with a product card may include a sub-block with images, a block with characteristics, a block with product variants

 

Video instructions - Xml file structure

 
  

Step 4.1 — categories

 

1) First, we define the root elements that contain categories and input them in the lines "Category._Item" and "Category._Root". The XPath to the root elements is inputed through "//"

2) Next, we input XPath for the attributes of the "category" tag: "id" and "parentId". XPath to the attributes is inputed via "//@"

3) Input XPath for the category name. To do this, we need to extract the values of the "Category" tag. The XPath for the category name will be "//text()"

4) Each product card has a tag that indicates which category this product has. Usually this tag is called "CategoryID". The XPath for "CategoryID" is inputed in the line "Product.CategoryId"

   

Video instructions - Input XPath for the category

 

Step 4.2 — a product

1) We define the root elements that contain the product card and input their XPath in the "Product._Root" and "Product._Item" lines. In some files there is no root element "Product._Root", in this case we input only "Product._Item"

 

Video instructions - Root element of product card

 

2) Then input the XPath to the values of the SKU (required input field), Name, Quantity, Price, etc.

 

Video instructions - The XPath to the values of the data

   

Step 4.3 — images

1) If the images are a separate block in the product card, then input the XPath to the root elements of the block with images and the tag that contains the link to the image

2) If the link to the image is registered as a separate tag in the product card, then input the XPath to the link in the line "Product.ImageUrl"

   

Video instructions - import images

 

Step 4.4 — features

1)If the features are located in a separate block in the product card, then input the XPath to the root elements of the block in the lines "Product.Features_Item" and "Product.Features_Root"

2) The XPath to the name and value of the feature is inputed in the lines "Product.Feature Name" and "Product.Feature Value"

3) If the features is located in the product card, then input the XPath to it in the line "Product.FeaturesExtra". First we input the name of the features, then "[--->]" and the XPath to the features. If there are several such features, then the separator between them will be - "[next]".

 

Step 4.5 — products with variants

1)Import product variants is similar to importing a product, first we also define the root elements of the block with product variants and input the XPath to them in the lines "Variant._Root" and "Variant._Item""

 

Video instructions - The root elements of the block with product variants

 

2) Next, input the XPath to the product variant data that you need to download

 

Video instructions - The XPath to the product variant data

 

3) product options with variants. If the options of products with variants are located in the file by separate tags, then input the XPath to it in the line "Variant.OptionsExtra". First, input the name of the option, then "[--->]" and the XPath to the option. If there are several such options, then the separator between them will be - "[next]"."

4) If the product options with variants are located in a separate block, then input the XPath to the root elements of the block in the lines "Variant.Options_Root" and "Variant.Options_Item". The XPath to the name and value of the option is inputed in the lines "Variant.Option Name" and "Variant.Option Value"

 

Video instructions - product options

 

Prestashop dynamic repricing


Use Prestashop repricing software. We develop repricing software since 2009.
Increase your sales and maximize profits via automated repricing software for Prestashop.

More sales


Give the best price at marketplaces
And get more sales. You can import competitors data from any external source: excel file, email,price monitoring api. PSQQQ will load real-time compatitors data and will use it for repricing your Prestashop products.

Required minimum profit guarantee


Software does not give you to sell items without min. profit. PSQQQ detects case if one of your competitors publish extra small prices and prevent you from selling your products without profit.

Different strategies for Prestashop repricing


There are 2 main strategy how to do repricing at your Prestashop store.
1 - without competitors prices.
2 - with competitors prices.

Get maximum profit using Prestashop repricing


Software for Prestashop will get you maximum profit if there is no competitors. PSQQQ detects event when there is no competitors for specific product and if it is true PSQQQ set max. profit % for that product automatically.

Create different repricing rules for your Prestashop repricing

PSQQQ has wide range of filters where and how to apply automatic margins rules for your Prestashop products for repricing.
PSQQQ is a unique software (online service, SasS) for Prestashop dropshipping integration! updating prices and stocks. PSQQQ is not only the best tool for automatic processing of supplier feeds (what is the core task for Prestashop dropshipping!), but it works with repricing and it works with products content, it is the best practices for working with feeds of suppliers and competitors, price monitoring and content web scrapers, flexible pricing and an effective, long-term investment for the sustainable development of the IT part of your business.

A lot of PSQQQ functions designed for Prestashop dropshipping!

You will create your feed based on the suppliers feed
”You
You will update your feed automatically on schedule
”You
Apply price and quantity repricing formulas for products
”Apply
Upload your feed to a store or accounting system
”Upload
””

Import feeds of any format

You will be able to import products from feeds of the following formats: and any of their options. In the user interface, you just need to specify the mapping of the columns / feeds and that’s it! These options are important for Prestashop dropshipping integration because it will allow you to start working with new suppliers quickly and the wide set of options for feeds processing will help you to prepare data for Prestashop the best way.
””

You can Export products data in the following formats

  • CSV, Excel, XML, JSON
  • API access
  • Direct import/update/sync to Prestashop
more details It is hard to suggest what is the best way for products export for your case because it depends on your experience. If you starting Prestashop dropshipping the best way for you to use direct products import/update/sync from PSQQQ to Prestashop. But if you have experience we think that you use some other tools for products post-processing and you will use PSQQQ for data preparation mostly. In this case preferred way for experiences users will be to export data via API to your own software for Prestashop dropshipping integration.
””

Options for feeds import

  • manual upload from PC
  • web link (http)
  • ftp
  • mail
  • dropbox
  • google drive
  • api
If you business is growing I believe that you have a lot of suppliers who share products feeds with you different ways. And for increasing frequency for products update at your Prestashop dropshipping store you need to automate products import from suppliers feeds. PSQQQ works here well and saves a lot of your time here. It can import new products data even each hour. more details
””

Connect new suppliers

  • check wholesales prices
  • increase the assortment
  • work with dropshipping model
  • check supplier prices
It will allow you to be different if compare with the other Prestashop dropshipping players. When they need to spend 1 week to connect with new supplier you can do this job for 1-2 hours. It will increase your SEO positions for google.
””

Compare Products

  • find the best supplier for each product
  • check competitors prices
  • manual and automatic functions for products matching
  • compare similar products
If you sell the same product from different suppliers PSQQQ allows you to select the best price and the best supplier for each product. Agree that if you have Prestashop dropshipping store you can publish the best price on your Prestashop store – your clients will like it!
””

Price calculation

  • by formulas
  • RRP/MRP furmulas
  • only for products with availability
  • filters by categories, brands, price ranges
  • the ability to set manually
  • suppliers priorities
  • shipping costs
You always need to recalculate final prices for your products, PSQQQ allows you to save time for that. Define formulas/rules/filters for price changes once and it will work for you each time when PSQQQ starts your MainFeed update. more details
””

RRP support

  • use RRP if defined
  • sell cheaper than RRP
  • sell above the RRP
more details If your supplies have RRP/MRP PSQQQ will take that into account when does repricing for your products. If you do not want to get penalties for your Prestashop dropshipping store you need to process RRP right way for all your products you sell. But if you want to “play” with RRP prices and to sell higher or lower you can use specific functions for this at PSQQQ.
””

Updating prices and quantities

  • fully automatic update
  • update by all formulas
  • set up once and forgot
  • protection against dumping
””

Product content

  • products with variants (combinatoins with options) are supported
  • all complex options are supported
  • import from other feeds
  • functions to update the required products fields
more details
””

Automatic processing of feeds

  • starting the processing of feeds on a schedule
  • automation of the chain of actions
  • automatic download of feeds by links, from mail, by API
  • automatic processing of imported feeds
more details
””

Content Search

  • database of 1.5 million products
  • automatic search
  • 1 product is added in 2 clicks
””

Scheduled start

  • all actions can be started automatically
  • download feeds
  • import new products
  • update old products
  • filtering by category
  • loading new currency exchange rates
  • updating prices taking into account the margin (according to all formulas)
  • export data to the site
more details
””

Competitors Price Monitoring

PSQQQ allows you to import competitors prices from external price monitoring software. It will allow you to compare prices and to use it for repricing.
  • compare prices
  • web scraper will collect product prices
  • import new data
  • use to recalculate your prices
””

Product change history

For each feed
  • shows new products
  • shows disappeared products
  • shows products where the quantity is changed
  • shows products where the price is changed
  • display of changes in graphs and tables
If it interesting to know what was changed at suppliers feed, where changed stocks, prices etc. PSQQQ shows these changes. If you want to start google AD campaign or facebook AD campaign for your Prestashop store you can analyze product changes before and to take products what fit your criteria.
””

Price analysis

  • analysis of price changes
  • analysis of changes in availability
  • analysis of suppliers’ feed
  • analysis of competitors’ feed
As you see there are a lot of built-in functions PSQQQ has for Prestashop dropshipping. Hope it will help your business grow and our team will help you to setup it for your case. We are ready to take any project on any state / stage and to help you to setup all right using the best practices for Prestashop dropshipping.

Prestashop images import - short instruction

Step 1. Import data into PSQQQ (to appropriate supplier section)

Step 2. Update Main Feed At PSQQQ - Run "Repricing" function

Step 3. Export updated data from PSQQQ into your Prestashop online store.

*** - All steps can be automated via scheduler.
simple mode - select column from combo-box
advanced mode - define column names PSQQQ is a Prestashop inventory management software. PSQQQ allows you to manage your Prestashop product and variation stocks using a simple grid view.

Features


- Stock status / Stock quantities
- Product Stock / Price history changes
- Show any Product Field (you can select any field to show, even features or options names / values)
- Shipping weight, dimensions
- Prices: standart, sale, wholesale, rrp, create new price types for your products
- Filter / sorting by any field , even by feature
- Export products data via API: custom export formats are supported: csv, excel,json,xml.
- Import products data from any source: http web, ftp, ssh, google drive, dropbox, amazon s3, email attachment etc.

Inventory management template for Prestashop

You need to define template for your inventory management process 1 time and PSQQQ will remenmer for all the next tasks.

Prestashop -> Amazon inventory management

Sync stocks / prices via Prestashop inventory management software. Amazon store API allows you to sync stocks automatically.

Inventory management google sheets for Prestashop

Allows you to take data from an external google sheet and to import into your dashboard.

Connect ERP / CRM to Prestashop


- SAP
- Dynamic 365
- Office 365
- Zoho We provide software (PSQQQ.COM) for Prestashop products import: you can import/update/sync products to Prestashop.
We develop this software and setup for our clients since 2009.
PSQQQ allows users to import products into Prestashop from different files: csv, xml, excel & update stocks.
We believe that Prestashop products import is a core function for your eCommerce business.

Do you need import/update products with Prestashop store?


Products Import
Csv products import
Xml products import
Excel products import
Categories import
Features import
Options variants import
Images import

Integrations
Supplier API integration
Translation via GooglaAPI
API Access
Export data

Repricing
Stocks & prices update
Multi currencies
Real-time currencies via API
Margin setup
Repricing by criteria

Automation
Scheduler
1 time setup - run daily
Custom scenarios


Prestashop products import software


- It means that client has a chance to solve custom cases.
- We are ready to develop custom logic.
- If any issue we can debug our software and to find reasons
- We can fix issues ASAP
- We know our software
- We optimize data processing speed always
- You receive new versions for free.

Prestashop products sync with focus on drop shipping

Prestashop drop shipping is the most popular case for our clients. Our software is ready for drop shipping.
- Multiple suppliers support
- Rule-based pricing
- Automatic suppliers data update
- Integration with CMS via API
- Optimized data import speed
- Own warehouse support

How to to setup products import for Prestashop via PSQQQ?

You can setup it itself: create a new account at PSQQQ and import products to Prestashop
Alternativly , We can do full cycle integration for your Prestashop store.
- Tell us what you need and we configure your account at PSQQQ for you.
- You just receive results - new products will be created old products will be updated(prices & quantities).

What is...
it is more than Prestashop products importer - find a lot of really useful functions: repricing, margin setup, multi currencies support, best price selection.

We develop Prestashop products import modules for our drop-shipping clients. We could adopt our software (add new function, add new supplier). Tell us what do you need to do and we will offer the best way to do it. You could utilize our in-house Prestashop products import software we develop since 2009.



Connect multiple suppliers

You can connect a lot of your suppliers easily. Add supplier, map fields and that is enough!

Rule-based pricing

Create formulas for price changes base on wholesales price ranges, categories, vendors etc.

Sync items, prices, stocks automatically

App allows you to run any task via scheduler.

Select The best supplier

App allows to select the best supplier per each item based on the "best offer method"

Dynamic pricing

Add competitors data and get dynamic pricing for your Prestashop store. Increase revenue at 7-12%!

Currency update

Update rates for currencies from your local bank api

Bulk Prestashop Products Import allows clients to import products into Prestashop store. Integration with Prestashop store is just a final function at all process. A lot of functions are embedded already and they were designed for drop-shipping business. Additionally we create custom data extraction configurations for our clients it is necessary. We built this service on top of our internal, in-house tools since 2009 and give you a way to manage feeds via web browser without any efforts and special skills.

PSQQQ .com was designed for Prestashop dropshipping, you can use PSQQQ for your dropshipping store easily because psqqq can parse any csv excel xml files or to be connected with suppliers API.
Prestashop is good for dropshipping and you can find what functions were implemented by us for Prestashop dropshipping

Inventory management for Prestashop

PSQQQ has functions for Prestashop inventory management. Get more info about that....

import
You can use PSQQQ as a prestashop import & update tool. it is compatible with the next prestashop versions : 1.5, 1.6, 1.7.
so you can use our tool for the next:

  • – prestashop 1.7 import products
  • – prestashop 1.6 import products
  • – prestashop product import module

Use prestashop importer – import product from csv xls xlsx. Prestashop automatic import can be defined via scheduler.
Prestashop import module allows you to update data by request or automatically. If you need automatic products import & update your source data have to be available via links or via emails.

import products
Tool was designed for bulk products import. If you need to import data with features, option, images you will find tool really useful.

import categories
Tool imports categories if you define categories from source file. Even if your source file has parent/child structure of categories you can easily import them into your prestashop store.
So you can do prestashop import categories subcategories using PSQQQ. You can define categories hierarchy via UI config and all categories will be imported.
import orders
PSQQQ does not import orders. If you want to import orders from csv to prestashop contact support team.
import combinations
Combinations for products can be imported into your store. You have to define combinations in UI config 1 time and all will be imported.
You can do prestashop import products with combinations from any feed like csv, excel or ( xml via support team). Prestashop csv import combinations can be setup by any user without support team if any issue contact support or read documentation.
import products csv
Any csv file can be imported. csv file config is the next: delimiter, wrapper, encoding, csv delimiter can be any like ‘,’ ‘;’ ‘~’ or ‘tab’. Wrapper can be also any like ‘”‘.

import customers
PSQQQ does not import customers, if you need that try contact support team.
import features
There are many ways exist how to import features into prestashop via psqqq. Via UI config define columns with features and they will be import easily.
import xml products
prestashop import xml is a big challenge for prestashop users because there is no any tools.
You can use our tool for “prestashop import xml feed”, you can define xml nodes with basic product info (name, sku, description, price, stocks) and to do prestashop import products xml.
Our “prestashop xml import module” has to be installed at your store, even your can use that for free: try – ‘prestashop import xml module free’. Prestashop xml feed import free for 14 days.

import csv products
Use PSQQQ for prestashop import csv. You can run import tasks manually or to run prestashop automatic import csv. Automatic prestashop import from csv can be defined via scheduler.
It will download your csv feed via link or via email or via dropbox, google cloud. You can take prestashop import csv example and to try free csv automatic import into your store. Use our module ‘import csv prestashop’ for direct data import into your store.

import products with images
You can do prestashop import product images using PSQQQ. Prestashop import images can be configured easily via interface. There are two ways for doing that. 1 – when image url defined in csv or excel or xml file. In such case tool takes image and upload it directly into your ftp folder. Be sure that you granted WRITE ACCESS for your image/p folder at prestashop installation.
“Prestashop import csv image url” is required for correct image import for case. It has to be jpg, png or bmp extension.

import excel
You can use PSQQQ as “prestashop import product with csv/excel module”. Do prestashop import xls, xlsx files. You can upload these files from PC/Mac or files have to be uploaded via link.

import products with features & attributes
prestashop import products with attributes feature is supported at PSQQQ.
prestashop import product features can be done via vusial configuration so you can import features itself form any csv or xlsx file. Even xml file with features / attribures can be imported but via contact with support team. Prestashop import attributes will be imported directly into your prestashop database.

import stock
Products stocks will be updated using PSQQQ. Stocks for basic products and stocks for combinations will be updated. There are 2 methods not stock combinations exist: 1 – by sku, 2 – by using string from options template {name-value}

import specific prices
If you need to import specific prices (discounts) from csv / excel files into your prestashop store use can do that via PSQQQ.