Our Blog

In this blog we have written couple of solutions for PayPal errors affecting different versions of Prestashop, we guess we would continue writing this as time goes on. Recently some of our customers complained to us about not being able to make a PayPal payment on our website or recieve  PayPal payments on their website. Actually somehow we missed the PayPal email update on the new security instructions for the Prestashop users. I'm sure the new PayPal modules would have updated this security issue but if you encounter problems , it is worth doing the following.

Making sure permissions are right on your modules/Paypal  folders

Upgrade your PayPal module to the latest version

Go to modules/PayPal/api/paypal_connect.php , ind the following line

@curl_setopt($ch, CURLOPT_SSLVERSION, 3);

Change it to @curl_setopt($ch, CURLOPT_SSLVERSION, 4);

Goodluck with your shop.

Recently expanded some of the services we are offering to customers and what that meant is taking on new staffs. As a business employing freelancers and employees that require flexible hours of working from home wherever they live, we wanted web based time tracking system that would allow workers to clock in and out and at the same time calculate their wages per hour / per day etc.  There are couple of them here and there online used as stand alone, web based or modules for  CRM systems. We wanted a simple system that would be dedicated solely for this purpose and after a good research online. Please welcome to Kimai.

Alright we all know that as an online shop owner, what you want is a way to do a bulk upload of all your products at once and also to  be able to do bulk editing . Prestashop has that capability but its handled in a CSV file. In Prestashop we found that many people are having problems doing this due to poor documentation that leaves room for users to practice trial and error on something that should be a straight forward thing. Please do not condemn  Prestashop, it is actually one of the best free E-commerce systems and i cant imagine using any other solution than Prestashop. 

Now let us walk you through the process of doing a bulk upload of your products, there are not so many tutorials of this problem and even the ones you have skipped the most findamental process.

1.In Prestashop BO  Go to Advanced Parameters  > CSV Import

2. Stay on this page and scan around the options for a while

3. On the option that reads "What kind of entity would you like to import?" , choose "Products" from the drop down. (this also applies to other things you may want to import like categories , etc.)

4. Once this is chosen scroll down (in P 1.6 ) and  observe the following listed Available fields

ID

Active (0/1)

Name

Categories (x,y,z...)

Price tax excluded or Price tax included

Tax rules ID

Wholesale price

On sale (0/1)

Discount amount

Discount percent

Discount from (yyyy-mm-dd)

Discount to (yyyy-mm-dd)

Reference #

Supplier reference #

Supplier

Manufacturer

EAN13

UPC

Ecotax

Width

Height

Depth

Weight

Quantity

Minimal quantity

Visibility

Additional shipping cost

Unit for the unit price

Unit price

Short description

Description

Tags (x,y,z...)

Meta title

Meta keywords

Meta description

URL rewritten

Text when in stock

Text when backorder allowed

Available for order (0 = No, 1 = Yes)

Product available date

Product creation date

Show price (0 = No, 1 = Yes)

Image URLs (x,y,z...)

Delete existing images (0 = No, 1 = Yes)

Feature (Name:Value:Position:Customized)

Available online only (0 = No, 1 = Yes)

Condition

Customizable (0 = No, 1 = Yes)

Uploadable files (0 = No, 1 = Yes)

Text fields (0 = No, 1 = Yes)

Action when out of stock

ID / Name of shop 

Advanced Stock Management 

Depends on stock 

Warehouse 

 

5. Open an excel sheet and paste each an every field into a column like the picture below. Make sure each field pasted ends with a comma. You may click here to see a faster way of doing the pasting .

 

 

6.  Now enter the appropraite value (do not use a coma at the end), you do not need to enter all, Prestashop would use the defaults where there is no value.

7. Save the excel file as csv coma delimited

 

8. Now come back to the CSV import page, change your field separator from semicolon(;) to coma(,). Go through the process of uploading your csv file.

 If you did the process right, you should arrive at a similar image below, assuming your products replaces the values below (It should match the fields right, where it is not matched, match the heading to the value by selecting the appropraite from the dropdown).

 

Please take note of the following :

1.

2. Enter the full image path in the  Image URLs (x,y,z...) field. Example http://www.mds-training.com/images/logo.jpg

 

Hope this helps, leave us a comment if you find this article good.