PrestaShop Store Manager

Official PrestaShop Store Manager Blog

PrestaShop 101 Import Questions

When it comes to PrestaShop import, a lot of questions and misunderstandings may appear. If you fail to perform it, there must be some nuance conflicting with the PrestaShop restrictions. In this article we are going to find solutions to most frequent errors and warning messages not allowing PrestaShop users to accomplish CSV import.

Product Import/ Category Import

Question: Where can I get a sample of a CSV file correct for PrestaShop import?

Answer: Find Download Sample CSV files grid on the right side of the .csv import page.

Question: "File type not allowed". From what files can I perform import?

Answer: The file format you are trying to upload is not supported by PrestaShop. You can import exclusively CSV format files.

XSL, TXT, ODF, PDF formats are not allowed.


Question: How can I convert a document into CSV file?

Answer: Open your document in a spreadsheet program, go to File - Save As - .csv (comma separated values).


Question: How many products can I import in one time?

Answer: There are no PrestaShop restrictions applied to inventory scope. The only thing you should take into account is your server capabilities.


Question: What if my column names do not coincide with the database or suppliers names?

Answer: In this case such columns will be ignored.


Question: "Only UTF-8 and ISO 8859-1 encodings are allowed. You can also upload your file via FTP to the following directory:XXX"

Answer: The file you are importing uses unappropriate encoding. PrestaShop allows only UTF-8 and ISO 8859-1 encodings.


Question: "An error occurred while uploading / copying the file prestashop"

Answer: If you came across this error, something is wrong with the place that you are copying the file to, or with the file itself. Check all warning messages, which have appeared on the import page. If you see this one: "The import directory must be writable (CHMOD 755/777)", ensure your permissions on import directory file are set to 755 or 777.


In other cases, be sure to check the file you are trying to import:

  • it should have only CSV format;
  • it must be encoded by UTF-8 or ISO 8859-1;

Question: "Property Product->customizable is not valid" "Property Product->description is not valid" "Property Product->ean13 is not valid" "Product (ID: X) cannot be saved" etc

Answer: Errors of such kind occur, if your .csv file contains some incorrect data. Check all of the fields very attentively. Also ensure the columns of your .csv file and the destination columns, which can be previewed on the second step of PrestaShop CSV import coincide. Do not forget to put "1" in "Lines to skip" field for the first line containing the field names to be skipped.

Another reason may be, that you have chosen a wrong import entity (i.e. Categories instead of Products etc.), that’s why your file columns do not coincide with the destination ones.

Question: "Rewrite link X (ID: X) was rewritten as X" "Rewrite link for friendly-url-autogeneration-failed"

Answer: Check ‘URL Rewritten’ field in your .csv. It mustn’t contain spaces, capital letters or special characters. (i.e. product name iPhone 8 Black should be rewritten as iphone-8-black). Besides, you shouldn’t leave it blank.


Question: "The category ID cannot be the same as the Root category ID or the Home category ID"

Answer: Do not put any of your categories under ID1, as PrestaShop uses it to identify Home category or Root category.


Question: "Two columns cannot have the same type of values"

Answer: Check the destination columns on the second step of PrestaShop import. Any of the columns can have the same values. For example, if "Active (0/1)" or "Name" value is chosen in two columns, it will provoke the error.


Question: How can I upload a downloadable product?

Answer: There is no way to import a downloadable product to PrestaShop backend without any assisting applications. You need to use PrestaShop Batch Downloadable Product Module or use some other managing tools like PrestaShop Store Manager, which allows to upload any type of product in bulk.


Question: Can I create a category while importing products?

Answer: Yes, just specify its ID and name in the corresponding fields of the same .csv file.


Question: Can I assign one product to more, than one category?

Answer: Yes. Using this formula “Categories (x,y,z)” you can add the product to a few categories simply separating them by a comma. For example: Categories (x,y,z) Jewelry, Accessories


Question: "No Name (ID:XX) cannot be saved"

Answer: Specify the name of ID:XX category. Probably, the field is blank or contains special characters.


Image Import

Question: "Error copying image: XXX"

Answer: The indicated root path or URL of XXX image is incorrect. Ensure the separator coincides with the selected one on the import page.


Question: How to upload a few images to one product?

Answer: Enter the image URLs into the corresponding .csv field, separating them by selected multiple value separator.


Question: What image formats PrestaShop is compatible with?

Answer: You can choose between two image formats - JPEG or PNG.


Question: How to get various sizes (base, thumbnail, mobile) of one product image during the products import?

Answer: In PrestaShop admin panel go to Preferences> Images>Image generation. Here you are able to set the image sizes to be applied to furtherly imported images. PrestaShop will generate different sizes of image automatically. More on this here: PrestasShop Image Preferences


Issues after the import is finished

Question: The import was accomplished successfully, however the products do not show up on the frontend.

Answer: Most likely reason is that your cache is not cleared or the page was not re-indexed. These procedures are strongly recommended after applying any changes to you store.

If you cleared the cache and fully re-indexed the page, but the products still do not appear at your shop, check the product quantity (minimum 1) and Active and Out of Stock values, which must be set as "1".


In this article we tried to list the most frequent and annoying questions and issues preventing PrestaShop users from a smooth and quick CSV import. Even if their number is much bigger, the reasons causing import errors are mostly common: unsupported file format, wrong encoding, incorrect .csv values, missed separators etc. That means, that before searching help on PrestaShop forums or accusing the platform in bad performance, you should first check yourself. The process requires high attention and thoroughness, so double check your every step and every import detail. Besides, do not forget to backup your store database to ensure not losing or damaging any data.

Please, contribute to this little guidance by specifying the issues you came across in comments to this article. We will try to help you out.

In order to make your PrestaShop store management more convenient and effective, you need to use some additional assisting programs. PrestaShop Store Manager is a perfect store managing tool allowing to handle any store operation remotely and quickly. You can download a free trial version and use it for 14 days with no extra fees.

Ready, Set, Christmas!

The countdown to Christmas has already started! eMagicOne company wishes you all the best for the upcoming holidays and offers you a great possibility to enhance your PrestaShop stores with innovative features and functionalities before you wrap for Christmas celebrations.

Christmas Countdown Sale

We have put a special gift under your Christmas tree to grant you happy season and eliminate your inventory handling troubles. So let's unpack it now!

Take advantage of amazing special deal on all the PrestaShop extensions developed by eMagicOne!

Be quick in ordering and get Christmas* discount,

applying code EMAG-VYGQ-XMAS storewide

Daily Deal

*Daily discount amount will be reduced by 1% each next working day till the offer expires. Hurry up to catch the best deal and make your Christmas more enjoyable with appealing savings.

There will be no bigger discount than today. So decide quickly! Find out what discount is offered today!

15 Days of Christmas

In celebration of the largest and most important holiday of the year, this Christmas offer will last until the 27th of December. This means 15 straight days of savings! Treat yourself this winter by grabbing this special offer. Merry Christmas!


Promo Details

  • 1 order = 1 coupon. Online redemption is required. Coupon is considered as redeemed when an order is completed, funds were charged and the license is generated. In case you apply coupon in the cart and do not complete checkout process, the discount won't be active once the usage is expired. Order is processed within a few minutes. In case your order has not processed yet, please place a new order (in case of duplicate, we will return the duplicated charged sum).
  • This code is not valid with other offers or discounts and cannot be combined with them.
  • The number of coupons is limited. The availability of codes one can check on our website https://www.prestashopmanager.com/order.
  • The discounts are time-limited and cannot be back-dated after they expire. Unused discounts are not refunded or returned in any way.
  • Discount does not apply to any services (only to products).

Best Monday in the Year

Black Friday is just over and we hope you all had great time enjoying the sales madness. If you missed it, that doesn’t mean the deals&savings and excitement are gone too. Cyber Monday is on its way and it will give you a second chance to get good bargain for your favorite software.

30% Off Storewide

Cyber Monday ends the biggest shopping weekend of the year with compelling savings! You have got a chance to grab our special, limited* offer and treat yourself with high-quality apps for your PrestaShop inventory management!

30% OFF

CBR-B6f7-MND


*The offer is limited to 15 usages! Hurry up to be among first 15 lucky shoppers, who make use of this discount.

Take This Chance

  1. Choose software products at our official website
  2. Add them to your cart
  3. Enter promo code CBR-B6f7-MND at checkout and receive 30% off!

Hurry Up!

Traditionally, Cyber Monday is one-day offer. We have decided to extend the promo till Tuesday November 28th, so you could make it and score one of the best deals of the year. So don’t forget to grab the deal before the end-date and enjoy your savings.

Enjoy this Cyber Monday, friends! And shop till your mouse breaks :)


Offer Details

  • 1 order = 1 coupon. Online redemption is required. Coupon is considered as redeemed when an order is completed, funds were charged and the license is generated. In case you apply coupon in the cart and do not complete checkout process, the discount won't be active once the usage is expired. Order is processed within a few minutes. In case your order has not processed yet, please place a new order (in case of duplicate, we will return the duplicated charged sum).
  • This code is not valid with other offers or discounts and cannot be combined with them.
  • The number of coupons is limited. The availability of codes one can check on our website https://www.prestashopmanager.com/order/.
  • The discounts are time-limited and cannot be back-dated after they expire. Unused discounts are not refunded or returned in any way.
  • Discount does not apply to any services (only to products).

Black Friday: Spend LESS, Buy MORE

If you've been planning and waiting for the perfect moment to pick up the best software for your PrestaShop store management at attractive prices, this is it! Black Friday is the time to spend LESS, buying MORE!

The Best of This Black Friday

We have brought back the best deal of the year and excited to share it with you. We know you have been waiting for it long time! So, make the most of it and buy highly functional PrestaShop Extensions at a heavily discounted price.

40% OFF coupon*

BLCK-CT7K-FRD

Get the best features at the lowest possible price! A one-time purchase for a lifetime license!

Shopping Weekend

On Black Friday we provide the biggest discount of the year and we probably won’t offer it again until next one! Thus, it seems that lots of people can not be satisfied, as it only lasts for 1 day.

Because of that, we decided to run a special longer Black Friday promo that will last till Saturday November 25th.

30 Discounts are Waiting for YOU!

* Note! The number of available discount codes are limited. So only 30 first buyers will be able to apply it!

So be sure to jump over to order page and claim your discount before it's too late!

Happy Shopping!


Offer Details

  • 1 order = 1 coupon. Online redemption is required. Coupon is considered as redeemed when an order is completed, funds were charged and the license is generated. In case you apply coupon in the cart and do not complete checkout process, the discount won't be active once the usage is expired. Order is processed within a few minutes. In case your order has not processed yet, please place a new order (in case of duplicate, we will return the duplicated charged sum).
  • This code is not valid with other offers or discounts and cannot be combined with them.
  • The number of coupons is limited. The availability of codes one can check on our website https://www.prestashopmanager.com/order/.
  • The discounts are time-limited and cannot be back-dated after they expire. Unused discounts are not refunded or returned in any way.
  • Discount does not apply to any services (only to products).

Renewed PrestaShop Amazon Integration Addon is Available in Beta Version!

Good news for PrestaShop store owners!

We are constantly working on improvement of Store Manager software and addons are not the exception.

prestashop amazon integration module

eMagicOne team is happy to announce the renewed BETA version of Amazon Integration that has just been developed.

Integrate your PrestaShop-based store with one of the world’s biggest marketplaces: export products, synchronize existing ones from your online store to Amazon, process orders to expand your business and increase the circle of potential clients.

You can download renewed Beta Amazon Integration version of the addon following this link - Download PrestaShop Amazon Integration addon.

Current Amazon Integration Beta version is compatible with Store Manager starting from version 2.38.0.1857. If you are using older version of Store Manager, than it is specified and want to update Amazon addon to the version 0.9.1.209, you have to update the application first.

Important note

Before the update, we recommend you to backup all Amazon Integration files to some local folder in case you need to roll back to older version of the addon. You need to save the following details:

  1. AmazonIntegration.dll file (to find it, navigate to C:\%ProgramFiles% \eMagicOne\Store Manager for PrestaShop\Plugins\)
  2. AmazonIntegration folder (can be found in c:\Users\%username%\appData\Local\eMagicOne Store Manager for PrestaShop\)
  3. amazon_integration folder (go to c:\Users\%username%\appData\Local\eMagicOne Store Manager for PrestaShop\LocalMySQLData\data\)
  4. Use Database Backup/Restore option to create backup of the tables, related to Amazon Integration, namely sm_amazon_categories and sm_amazon_products tables.
  5. prestashop amazon integration amazon tables

Let us take a closer look at the list of new features and improvements this Beta version delivers to PrestaShop users

Features:

  1. Product listings have been added in current version of Amazon Integration.

  2. prestashop amazon product listings

  3. The log list of recently performed operations is now available in this version of the addon.

  4. prestashop amazon integration logs

  5. The possibility to schedule and execute task has been implemented.

  6. prestashop amazon integration scheduled task

Improvements:

  1. Now, the parameters of the window are saved after closing the Amazon addon. Correspondingly, the same size of the form is uploaded and used after next opening of the Integration.
  2. The list of suggested categories is now available to use at the step of mapping categories.

  3. prestashop amazon integration suggested categories

  4. The Amazon category search has been improved with quick search filter.
  5. The possibility to save and load the listing settings has been added.
  6. The placement of Integration elements has been changed. The interface of the addon has been enhanced as well.

  7. prestashop amazon integration interface

  8. The ability to choose the field to export product quantity from has been added in new BETA version of Amazon Integration addon.
  9. Export quantity of products according to specific rules is available in this version of addon.

Once all of the backups are done, you can proceed to the update following these steps:

  1. Download Amazon Integration installation .exe file on your PC. Proceed with installation steps with a special setup wizard. It is recommended to close Store Manager before you continue with further steps.

  2. prestashop amazon setup wizard

  3. Read and accept Licence Agreement.
  4. Select Store Manager the Integration should be installed on (Store Manager for PrestaShop in your case).

  5. prestashop amazon installation

How to return back the old version?

There can be reasons why you might want to get back the old version of Amazon Addon you have been previously using. For such case, you should proceed with the following steps:

  1. Go to Raw Table Editor section accessible in Tools section of Store Manager.
  2. Filter the tables related to Amazon addon among all the available ones.
  3. Highlight the filtered tables and launch to Script to Clipboard/Drop option in the context menu.

  4. prestashop amazon tables

  5. After that, proceed to Custom SQL tab, paste the tables and press Execute SQL button.

  6. prestashop amazon expression

  7. Close Store Manager and copy the previously saved old AmazonIntegration.dll file you have been using to C:\%ProgramFiles%\eMagicOne\Store Manager for PrestaShop\Plugins\. Proceed the same way with AmazonIntegration folder to c:\Users\%username%\appData\Local\eMagicOne Store Manager for PrestaShop\ and amazon_integration folder to c:\Users\%username%\appData\Local\eMagicOne Store Manager for PrestaShop\LocalMySQLData\data\.
  8. Restore tables related to Amazon, previously saved in .sql file.

Please, note, that Amazon Integration is running in demo mode by default. This means, that you will be able to export up to 10 items for testing. Find more details on Amazon Integration following this link - https://www.prestashopmanager.com/integrations/prestashop-amazon-integration/

*Amazon Integration is already built in Store Manager software and cannot be used without it. If you do not have Store Manager, try Trial version of the application and check all the possibilities of the addon and other functionality Store Manager offers.

Wishing You Happy Thanksgiving

Thanksgiving is coming up, and we are extremely excited to share the spirit of upcoming holidays! These are very special days and there wouldn’t be a better occasion for us to express our gratitude and offer exhilarating discounts.

Thanks

All of us at eMagicOne are grateful to everyone who’s joined our community throughout all these years. You’ve helped us grow and build better software products for your PrestaShop online stores.

Everyday we are tying harder and harder to reach higher goals and bring top-level user experience for you, our dearest customers. Thanks for keeping us inspired and encouraged!

Giving

This festive season, eMagicOne offers a superior shopping experience to enhance your PrestaShop store with extensions that include specialized features and improved functionalities.

So getting back to discount, as a token of our gratitude on this Thanksgiving, we are providing great discounts on PrestaShop software, to show our appreciation for all our amazing customers in the best way possible!

$100 OFF voucher
TNKS-S944-GVN

Limited Offer!* (Reduced by $5 each day)

Weeks of Gratitude!

*Note, the number of coupons is limited and the discount will be reduced by $5 each day until 11/30/2017!

Remember this is not a long period and if you hesitate now, you might forget it and miss the chance to get the best deal! So get your hands on our holiday offer today!

Happy Thanksgiving and a joyous holiday season!


Promo Details:

  • 1 order = 1 coupon. Online redemption is required. Coupon is considered as redeemed when order is completed, funds were charged and license is generated. In case you apply coupon in the cart and do not complete checkout process, the discount won't be active once the usage is expired. Order is processed within a few minutes. In case your order has not processed yet, please place a new order (in case of duplicate, we will return the duplicated charged sum).
  • This code is not valid with other offers or discounts and cannot be combined with them.
  • The number of coupons is limited. The availability of codes one can check at website’s order page.
  • The discounts are time-limited and cannot be back-dated after they expire. Unused discounts are not refunded or returned in any way.
  • Discount does not apply to any services (only to products). Minimal order subtotal should be $150.

Winter is Coming!

Summer almost over, which means that winter is coming. Hmm, ... don’t we still have 3 autumn months ahead?

Alright, those months are still on the calendar so you can take your time. However, the truth is that time flies and the holiday shopping season with back-to-school, Halloween, Black Friday and Christmas will be here before you blink. Wait, have you just done it?

Don’t wait to gear up for busy festive period!

emagicone christmas in august

It’s Never Too Early To Get Ready to Sales Season

It might seem a little early to think ahead to the holiday season now, when it is still summer. On the other hand, this is a perfect time, as this period is pretty slow and quiet. So starting Christmas planning now will eventually bring you abundant of benefits on December.

Use these days to invest all your efforts to clear out your old stock, update existing inventory, plan upcoming top-notch holiday promotions, review and diagnose your PrestaShop store for issues to get it in tip-top shape to ensure that you are ready, before holiday rush begins.

Separate the Chores From the Celebration

One of the most convincing reasons to make holiday preparations early is less pressure. While your competitors will be in a rush, making last-minute preparations and dealing with problems, you will avoid this stress and enjoy festive period.

Automate routine operations and enjoy profitable results with Store Manager for PrestaShop software!

With the app you will be able to:

  • work offline without waiting for browser page to load
  • add/edit products in seconds with smart import functionality, supporting upload from the files of .csv, .xml, .xls, .xlsx, .ods and .txt formats
  • set up scheduled updates of your inventory, synchronizing it with supplier's data automatically
  • massively modify item details using multi-editors, for example, setting price mark-downs by value or percentage in seconds
  • create multiple statistical reports up to your needs
  • diagnose your store for SEO issues
  • easily integrate with additional sales channels and accounting systems.

Christmas in August

Do less, enjoy more! Ensure yourself an organized Christmas with our software.