watman10
Members-
Posts
15 -
Joined
-
Last visited
watman10's Achievements
Newbie (1/14)
1
Reputation
-
Hi, I have a client who is currently running a Prestashop store (1.4) Their business is custom mobile phone, laptop, games console skins They require a mechanism similar to the one offered at http://www.online-product-designer.com/online-custom-ipod-design-software-application-tool.php to allow customers design their own skins etc. Does anyone know if there is such solution for Prestashop 1.4 or perhaps is there anyone up to the challenge of developing a module? Thanks, M
-
Hi, I am helping a business move to Prestashop I have a CSV file from their previous store containing all products etc. I have re-layed out the CSV under the correct headings as per the CSV upload section in the Admin page of Prestashop. When I upload the CSV, I get the following issues.... Any help is much appreciated. If anyone has a blank CSV template for prestashop i could see this being of help also. 1896 errors Name * (ID ID) Cannot be saved Product -> id_tax_rules_group = Tax rules id (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved
-
Hi, I am experiencing difficulties when importing products from CSV into Prestashop 1.4.4.0 I have set up the CSV with all the correct headings but when i go to import the products i get the following: 1896 errors Name * (ID ID) Cannot be saved Product -> id_tax_rules_group = Tax rules id (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language. (ID ) Cannot be saved Product -> quantity is emptyProduct->name is empty for default language etc etc Anyone have any ideas?? Kind Regards M
-
Database Question (Upgrade)
watman10 replied to watman10's topic in Upgrading PrestaShop from a previous version
Thanks Raphael, The DB server seems to be on a go slow, i am trying to strip out the historical visitor data for now. any other ideas to speed up site response? M -
Hi, I am looking to migrate from Prestashop v1.3 to v1.4 However, our database is over 3GB in size and is not easily downloaded and re-uploaded. Is anyone aware of how I can strip historical data out of it (Just want to be left with the essentials - Customers, Products, Orders etc) Any help is much appreciated. M
-
Hi, I am not personally aware of the company you use for hosting, however I can confirm that one hassle free host for sure with Prestashop is Spiral Hosting (http://www.spiralhosting.co.uk) I have a couple of very high traffic sites with Spiral and its never a problem, they do shared, dedicated and VPS (Hyper-v) and they are not that expensive - Plus 24 hr support tickets :-) If you do decide to use them let them know that I referred you! M
-
Hi, It is possible to export the database from 1.3 to 1.4, however it does depend on how good you are with database admin. I know going from 1.2 to 1.3 there are a few core modifications to the database tables. While I have not migrated 1.3 to 1.4 yet, judging by the mass improvements, I am guessing similar changes are required. M
-
How to upgrade my shop for Beginners
watman10 replied to wildcat's topic in Upgrading PrestaShop from a previous version
Hi, Can you give me some information on the upgrade. Information such as the following would be helpful: * Version you are upgrading from * Version you are upgrading to * Do you require your old database? * Hosting type (Linux/Windows) Thanks, M -
Path not working correctly
watman10 replied to Pinkloveshy's topic in Upgrading PrestaShop from a previous version
Hi, Ok I have taken a look at your link and the htaccess file should be ok. It looks to me like there might be an issue with the directory that your new store is uploaded to e.g. http://www.shorts4u.com/shop/store/en/5-mens-shorts My suggestion is to re-upload your store to a directory such as http://www.shorts4u.com/testshop See if this works. If you are still having problems then my best suggestion is to put a zip file of the prestashop directory and database on your FTP and I can assist further. Bes Regards, M -
Path not working correctly
watman10 replied to Pinkloveshy's topic in Upgrading PrestaShop from a previous version
Hi, Try removing the .htaccess file from the FTP. Make a backup of it on the computer and then delete it from the FTP. Regards, M -
Details: - Upgrading to Prestashop V1.3 from older version using an existing database Problem Statement: - When a customer attempts to register while at Cart > Checkout in the front end, they are presented with an error "an error occurred while creating your account" Resolution Statement: - There have been changes to the database infrastructure in V1.3 (AFAIK). This causes the php sql query to fail as it has an expectancy for several columns in 3 tables which does not exist in the old database. - The new framework is unable to assign the customer to a specific group as the group column is not present in the old database Resolution Fix: - Launch preferred DB editor (Recommended: Heidi SQL 6.0 EXPERIENCED USERS ONLY http://www.heidisql.com/) – Navigate to table “PS_CUSTOMER” – At position 3 add column “id_default_group” of types “INT 11” and default value 1 and save changes to database In the same table "PS_CUSTOMER" - At position 15 add column "dni" of types "VARCHAR 50" and default value NULL and save changes to database Navigate to table "PS_CUSTOMER_GROUP" - At position 2 ensure that column "id_group" is added. This is most likely already present in the older DB, however if it is missing, at position 2 add column "id_group" of types "INT 10" and default value 1 and save changes to database Navigate to "PS_ORDERS" - At position 20 add column "total_products_wt" of types "DECIMAL 17,2" and default value 0.00 and save changes to the database Refresh your browser and attempt to register again at Cart > Checkout - This issue should now resolve. SCREENSHOT ATTACHED
-
Details: - Upgrading to Prestashop V1.3 from older version using an existing database Problem Statement: - In the back-end, navigating to Payment > Vouchers returns an error "Bad SQL Query" Resolution Statement: - There have been changes to the database infrastructure in V1.3 (AFAIK). This causes the php sql query to fail as it has an expectancy for a table which does not exist in the old database. Resolution Fix: - Launch preferred DB editor (Recommended: Heidi SQL 6.0 EXPERIENCED USERS ONLY http://www.heidisql.com/) - Navigate to table "PS_DISCOUNT" - At position 4 add column "id_currency" of types "INT 10" and default value 0 - Save changes to database - Refresh the vouchers page in your browser and the issue should be resolved SCREENSHOT ATTACHED
- 1 reply
-
- 1
-
Hi, Thanks for your response. I have modified to show errors and refreshed, still the same situation - Blank screen. Does anyone know what directories must be chmod so I can rule that out? Thanks!
-
Hi, I am having problems when I try to migrate Prestashop from our test server to our live server. Both servers are identical in every way I copied both the files and the database across. When I try to view the shop webpage, i get the favicon but nothing else (Blank page) When I go into the admin section, I can log in and view/change everything. Any ideas what might be causing this? Thanks, Watman10