Jump to content


  • Posts

  • Joined

  • Last visited

About nnapier

  • Birthday 09/01/1983

Profile Information

  • Location
  • First Name
  • Last Name

nnapier's Achievements


Newbie (1/14)



  1. Why would they fix it? You wouldn't blow $50 - $100 on a custom module if they did. PrestaShop is a bit of a mess, but in the end all of the cart systems are. They work just enough so that all of the money can be made by addon's and fixes. I'm a systems engineer with 15 years of programming and web dev experience and I still waste days hacking in the simplest things. The themes are all complete garbage that never work unless you have the time and knowledge to completely rework most of the layouts and custom module integration. I guess it is just what we can expect for a customized site based around a cart system that we don't write ourselves. I actually had to setup another Prestashop site and used my directions about 6 months ago and it did eventually work. It took me 2 - 3 times to get it perfect so I would keep trying or just consider buying one of the custom modules to make it work. Best of luck to you.
  2. Getting the same error now. It's showing "Failed to load resource: the server responded with a status of 500 (Internal Server Error)" in the chrome developer panel. No freaking clue how to fix this though and I can't find anything about it. It just started happening this month when I went to add a new product and upload an image. It looks like only images under 100KB will upload, but anything about that fails. Uploading JPG's here and I don't get whats going on. Did you ever find a fix?
  3. You would need to create a tax zone for each EU country with the VAT percentage. I don't know of an automatic easy way to do it without buying a quick fix module. I looked on Google a bit and didn't find much on creating Eu VAT tax rules beyond doing it yourself one by one or by just spending the $60 USD for the module. Best of luck. Everytime I read about the crazy VAT setup, I am thankful to be somewhere with simple tax rules.
  4. After doing a ton of research and searching on the topic of setting up specific tax amounts depending on counties, I found the following idea posted: Setup a different tax for each of the unique tax amounts. Create tax rules for each areas that charge the different amounts and use a zip code range. So once you look up the zip codes you will see a very massive problem with the only approach that I could find: Zip code ranges do not work in any way as it's one zip code to another zip code and they are seen as simple numbers by the system. If a users zip code falls between the ranges then they are charged the specified tax. Zip codes are not perfect and never actually line up in proper numeric form as geography doesn't work that way. The easiest way to fix the issue above would be for PrestaShop to change the range field to allow for comma separated zip codes. That isn't happening right now so I made my own way. My requirements for the state of Pennsylvania were as follows: Allegheny County = 7% Philadelphia County = 8% All Other Counties = 6% This is what I did to solve my issues (Attached is a screenshot of the excel of what it looks like): * Warning, requires excel and phpMyAdmin knowledge (can access through cPanel) and probably will not be an option for hosted solutions. My solution was for PrestaShop so this might need to be modified depending on your version. Create 3 taxes: PA Statewide (6%) = Value: 6 PA Allegheny (7%) = Value: 7 PA Philadelphia (8%) = Value 8 Create a Tax Rule called "PA NEXUS STATE TAXES (6 to 8%)," but feel free to name it how ever you want. Within the new Tax Rule view: Add 3 associated rules, one for each of the taxes that you created above, by clicking the "Add a new tax rule" button. Choose the associated tax (in this case the 6%, 7%, and 8%), set the behavior as "This Tax Only" and give each an easy to remember title as you'll need that later. Go into phpMyAdmin by logging into your host backend and finding the link within cPanel or whatever UI they have setup. Once you are within phpMyAdmin, locate your PrestaShop database and expand the table listing. The name of the database would have been chosen by you or your host. Locate the table entitled "tax_rule" and open up the browse view.Scroll to the bottom and find the tax rules that you just added. Search on google for "all zip codes in philadelphia county PA" and find a listing. I ended up using the following, but the link might be dead by the time you see this:http://www.zillow.com/browse/homes/pa/philadelphia-county/ Copy all of the zip codes into excel into the "A" column on the 1st row. Search on google for "all zip codes in allegheny county PA" and find a listing. I ended up using the following, but the link might be dead by the time you see this:http://www.zillow.com/browse/homes/pa/allegheny-county/ Copy all of the zip codes into excel into a second column. Search on google for "all zip codes in PA" and find a listing. I ended up using the following, but the link might be dead by the time you see this:http://www.unitedstateszipcodes.org/pa/ In this case it was a full table so I had to copy the whole table, paste into a second sheet, and then cut out just the zip code column and paste into a third column back on the sheet with the philadelphia and allegheny columns. Select all three columns and under the "Data" tab in the ribbon, select "Remove Duplicates." Depending on your Excel version, you might have to look up where to find this. Once you have removed duplicates (Excel will remove the secondary duplicates in the overall PA listing so that the values in the Allegheny and Philadelphia are still good), do the following: Cut the allegheny column and paste the values below the philadelphia column with a few rows in between so that you can see the break. Cut the PA column and paste the values below the philadelphia and allegheny combined column leaving a few rows so that you can see the break. In an empty column next to the now combined column, do the following in the first row: ="INSERT INTO tax_rule (id_tax_rules_group,id_country,id_state,zipcode_from,zipcode_to,id_tax,behavior,description) VALUES ('54','21','38','"&A1&"','0','53','1','PA Tax - Allegheny County (7%)')," Replace the VALUES () area to match the column values for the associated tax within your "tax_rule" table in phpMyAdmin. Please note that for the first batch we chose Philadelphia so you want to have it match up with that tax rule. Now in the second row below the first one you just made, do the following: ="('54','21','38','"&A2&"','0','53','1','PA Tax - Allegheny County (7%)')," Replace the area between the () to match the column values that you just chose in the first row with the only difference being the "A2" reference. Hover your mouse over the lower right hand corner of the cell that you just created until it becomes a black cross and left click and hold. Drag you mouse down to the end of the Philadelphia listing and let go. Repeat the steps above from the "INSERT" method for the allegheny and PA statewide listings until you have one big column of SQL value inserts that form one major insert query. Copy the SQL insert column values from the column to your clipboard. Open phpMyAdmin and click the "SQL" button.Paste your big insert query into query field and click the "GO" button to execute it. This may take a few minutes as it can be a ton of values. Once the big query is complete then phpMyAdmin will notify you of the query success. If it fails then look at the error and figure out what happened. I had an issue with the column names so you might have to play with those. Now hop into your PrstaShop backend and check the tax rules listing and make sure that all of the new zip code values are there. Feel free to delete your first 3 example rules that you created as all the other values you entered will now overwrite them. Test the result in your cart to make sure that taxes are being applied properly. This option is a few minutes of work, but it should work for any state as long as you can find all of the zip codes and figure out which zip codes to tax at what rate. Thanks for reading and I hope that this saves others a ton of work in the end.
  5. Hey, I know that this question is very old, but it ended up being the supplier that was associated with the product. I never really found a way to fix the supplier, so when I edit a product, I first uncheck the supplier and save. Then you will be able to edit the product and save it. Once you finish making your changes, just check the supplier and save again. Not really a fix, but a work around.
  6. Thanks ahead of time for your help! I wish to do the following: Create a BOGO cart rule that allows a user to buy one get one free an unlimited amount of times.I can do this easily buy doing a cart rule with a minimum amount and a 50% off selected products, BUT if a customer adds an odd number of items then 50% comes off all items in the cart. I am trying to find a way to only apply the discount on an even number of items so that the idea of buy one get one is maintained. Has anyone ever ran into this and do you know of a solution? I'm using Prestashop Current Settings: Partial Use: YES Minimum Amount: $38.80 (all products are at least $19.40) Total Available: 999999 Total Available for each User: 999999 Restrictions:Product Selection (selected all non-sale items) The cart must contain at least: 2 products Apply a discount: Percent (50%) Apply a discount to: Selected Product(s) My brain is fried so if you know a way then you are my hero!! Thanks!
  7. Hello Everyone! This is my first post, but I figured I should make it since I was saved by this awesome forum this morning: The Prestashop 1.6 PayPal module and PayPal Manager setup is confusing and there is zero documentation. Everyone ends up blowing $50-$100 because they can’t figure out how to set things up correctly on both ends. I found out that the major issue has to do with using a second user that you create with admin abilities in PayPal Manager and adding proper Error and Cancel URL’s under the PayPal Manager Service Settings Setup in the form of http://www.yourdomain.com/order. This corrects the annoying “No Payment Method is Installed” error when you try to checkout when you attempt to setup PayPal Advanced. I’m not sure if the complexity and annoyance of setup is intentional by both PayPal and PrestaShop to push users into buying unneeded extra modules, but it is what it is. I've saved the guide as a PDF and posted it as an attachment, so please see the attachment. A big thanks to user "surferboy" for providing the info that helped me fix this issue. Thanks everyone! PrestaShop-PayPal_Advanced_Setup-using_default_free_module-GUIDE-05-12-15.pdf
  • Create New...