WordPress database error: [Table 'sicksens_wp221.wp_categorymeta' doesn't exist]
SELECT category_id, meta_key, meta_value FROM wp_categorymeta WHERE category_id IN (323) ORDER BY meta_id ASC

PrestaShop Archives - Naper Design | Naperville Web Design and SEO

PrestaShop Unfiltered – Latest News on Prestashop Sites

OK, so PrestaShop is likely the most awesome script to ever be developed for PHP based e-commerce.

That being said, it can be a royal pain in the ass.  When put to the test of the modern web, and of modern web design, PrestaShop 1.3 appears to be unmatched in both versatility and ability.  The problem with something so incredibly strong is that it comes with specifics that we didn't understand when we began using.  Add in that most of the support for PrestaShop is written in French or German, and you have long nights using the Google translator to understand a new program.  Here are three of our greatest problems with this Sports Clothing and Memorabilia Website and the solutions we found for them.

1.) Data Entry-

The default Preshop CSV Uploader has problems with the use of certain type symbols in the uploaded descriptions.  Our client is one of the best Fans Wear and Online Sports Clothing stores in the Chicago Area, so dollar signs and trademark emblems are a must have.   The solution is to update these post-upload.  You also can't re-appoint item numbers once the first upload has been completed.  This means careful planing and strategy must be incorporated into building your databases.  Planning the database well, and having a map of the item numbers and category numbers will make sure that you can more easily find problems and errors within the tables.  Brett recommends creating an ID numeric system for the products as well.  Uploading the numbers through the CSV uploader will allow you to designate their ID instead of PrestaShop giving them an arbitrary listing.  Again, this allows tracking of errors and problem within the tables.

2. Styling

This one was news to me.  Most of the minor styling within PShop is still conducted in PHP and Module areas.  What this means is that CSS will not save all situations, and sometimes makes it far worse. The PrestaShop Modules are given specific table locations, while still working in the new DIV and Class structure.  While the global CSS style sheet is used for most every aspect of design, it's more of the finishing piece for an already designed build.  This seemed limiting in design structure at first because we were so used to using CSS for all web styling.  The construct with PHP tables is actually much more decisive than most builds we've used in the past.  In many ways, it's like the fundamental Layout of a rails system.  For any piece of the site, code can be adopted, or dropped all together when it is intruding.  As long as the code is visual and non-functional, the site can function without it. This allows for extra code to be inserted in and multiple expressions to be used in its fashion.

3. The .htaccess will not work on the back side of Wordpress.

PrestaShop 1.2 and 1.3 offer a strong set of strings for a working .htaccess and therefore, friendly urls.  The problem is that when placed as a back file system of a Wordpress build, and any other .htaccess driven sites, the database will always collapse when making categories.  While there is some information out there about this phenomenon, Brett and I may have been the first team to really get rapped up in putting PrestaShop shopping carts on the Back side of a blog url. All we can tell you is this.  Wordpress is by far the most SEO friendly foundation for any dynamic website or web development.  We believe that the wordpress development on the front end of the online store should be more than enough to boost the site relevancy.  If anyone has found a way to fix the .htaccess in a way that not only works, but works behind wordpress, please let us know.  Up until now, all solutions have been very limited in the amount of categories that they would allow.
Read more...

Working with Attributes in PrestaShop

I have been working with PrestaShop now for over a month. One of the challenges is getting the attributes to work for the products. If you try to upload the attributes with the products in the csv file you will get a very disappointing side effect. The attributes will go to the cart all together so the store has no way of determining what attribute you are ordering. On the site I am working on we needed sizes for shirts. The sizes had different prices as well. The cart was catching the price change but put all of the sizes on the shirt not just the one size you would want to order. I figured I could just make separate categories for the product by size and crashed the whole site. Our hosting service has been working on this problem ever since. I have learned that the new php does not like having over 300 categories. My client's site had over 1300 categories when I crashed it. I then realized I needed to get the attributes to work. I found you can import the attributes separately and they will work just fine. Then you are forced to add the attributes to every product individually and they will work the way they are supposed to. I will be putting pics up soon of this process.
Read more...

New Hurdle with PrestaShop

I have had tons of problems with PrestaShop. My most recent problem is coming up when my price changes due to a combination. The price in the buy_block is wrong and doesn't match the price in cart that is correct. I checked the tax options and turned them off because they don't work either. I would like the simple things to work when I'm using such a popular e-commerce solution.

Read more...

PrestaShop Devlopment for e-Commerce in Chicago

We are pleased to announce that Naper Design will be developing our first major PrestaShop Template and Website.  While we've enjoyed playing with it for some time now, we will finally have the opportunity to develop a major site with this highly versatile E-Commerce solution. Here's a description of PrestaShop from the core site: "PrestaShop e-Commerce Solution was built to take advantage of essential Web 2.0 innovations such as dynamic AJAX-powered features and next-generation ergonomy. PrestaShop guides users through your product catalog intelligently and effortlessly, turning intrigued visitors into paying customers" PrestaShop began as a network and community maintained e-Commerce Software. The script is maintained in much the same way Wordpress is.  The most up to date version of PrestaShop can be downloaded here. It offers the Following:

Front-office

  • Featured products on homepage
  • Top sellers on homepage
  • New items on homepage
  • 'Free shipping' offers
  • Cross-selling (Accessories)
  • Product image zoom
  • Order out-of-stock items
  • Customer subscription & user accounts
  • Payment by bank wire
  • Google Checkout module
  • Cash-On-Delivery (COD)
  • Preconfigured for Paypal

Back-office

  • Unlimited categories & subcategories, product attribute combinations, product specs, images, currencies, tax settings, carriers & destinations
  • Real-time currency exchange rates
  • Inventory management
  • Unlimited languages & dialects
  • 100% modifiable graphic themes
  • Newsletter contact export
  • Alias search
  • SSL encryption
  • Visitors online
  • Customer groups
Our first site built in the platform (fr mainstream anyway) will be Malloys Finest. - the site that we are preparing for them can be found here-
Read more...

Template Monster Releases New PrestaShop Themes

Brooklyn, New York, July 7th 2010 - TemplateMonster.com, the Internets largest templates provider, introduces brand new PrestaShop Themes which are basically a brand new eCommerce solution designed specifically to provide the customers with the speedy and very lightweight tool in setting up their own PrestaShop stores. PrestaShop is a new feature-rich and open-source eCommerce software which has a very powerful back-end for its size. Combined with decent and affordable designs PrestaShop is an efficient eCommerce shopping cart solution available for small and medium-sized online businesses. PrestaShop multilingual eCommerce system is fully customizable, quick and simple to install. And the site owners will appreciate its flexibility as it supports unlimited categories, sub-categories and image pictures. Besides, the store admins can manage the inventory, customers, orders, and payments easily. According to companys authorities, PrestaShop themes provided by TemplateMonster are developed to take advantages of this new shopping cart system. The themes are HTML/CSS Validated and optimized for fast page loading, plus they support all major browsers and have built-in jQuery elements for even more spectacular design. David Braun, CEO of the Template Monster, said, "Our customers have been asking us to launch PrestaShop themes for many months now. And today we can proudly claim that TemplateMonster now offers innovative PrestaShop themes brushed and polished by our website design pros. Dedicated to providing unbeatable functionality for customers online eCommerce presence, our PrestaShop design solutions ensure youll fully enjoy fantastic functionality of PrestaShop. Not to mention that the themes are extremely easy to modify. And of course we are eager to extend our PrestaShop selection by adding more and more new designs into this product type. So be sure to check back for more premium quality PrestaShop templates!" Previously the company has launched the Free PrestaShop Theme for cell phone store. This template is still available for download at Free PrestaShop Theme download page.
Read more...