Show Posts


Messages - mattpb

Pages: [1]
1
Thank you.  Will do!

2
General Support / Re: Can't import products
« on: August 25, 2016, 11:37:32 PM »
Thank you for your reply.  I figured out the problem to this particular issue and will share my conclusion for the benefit of the community.  I exported a full product (meaning every product table) CSV from the admin panel.  Thus there were multiple "product_id" columns in the spreadsheet, ordered as they appeared in certain tables (i.e. _product_description table has a product_id column, as does _product_categories, and so on).  The real mistake I made was filling in the product_id column that was part of the "products to categories" table with our id numbers, but not having a associated category id to all of the product ids listed.  Hence the error message.  I went back and corrected this and the upload was successful, even though prices and dates were off because I used Excel.  Trial and error, lol.

3
Hi.  When attempted to upload CSV with product data, I get the following error message:

Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 32 bytes) in /home/wiebadweb/public_html/store/ecommerce/core/lib/data.php on line 447

This is new and I was under the assumption that I had raised the upload limit, though this may have been prior to the 1.2.8. update.  Would the upgrade return settings back to default?  I would very much appreciate your assistance on rectifying this matter and thank you for all your help so far.

4
General Support / Re: Can't import products
« on: August 21, 2016, 03:52:27 AM »
I have still had zero success importing products through the AbanteCart CSV/TXT/XML Importer.  I have thousands more to do and need to figure out what I'm doing wrong.  It'll give me a count of successful queries and listings created, but then I always get an error and it seems to knock each row (line item, listing) out and I end up with no change to Inventory or Database when checking phpMyAdmin.  These are the latest  error messages I'm getting:
Missing relation ID category_id for update_or_insert action in table products_to_categories. Skipping.
Missing relation ID category_id for update_or_insert action in table products_to_categories. Skipping.
Missing relation ID category_id for update_or_insert action in table products_to_categories. Skipping.
...

5
Configuration / Re: Product controller error message
« on: July 14, 2016, 02:06:02 AM »
Thank you for replying and please excuse my delay.  I am running version 1.2.7 and I do believe that I figured out the source of the issue.  When making adjustments to the product database tables using phpMyAdmin, I had set "product_id" as my primary key, but did not have "auto-increment" enabled, therefore when manually entering a product via the AbanteCart admin control panel, it was not placing the new product at the end of the table as it should (going off the last product number read and adding +1 to the new), but rather applying the number "0" as the product number and not allowing it to be read and visible in AbanteCart.  It seems that there has to be a direct correlation between the database's successive progression of product numbers (if that is your primary key) and creation time-stamps in order to be visible for use in AbanteCart (i.e. if product 100 has a timestamp of 2016-14-07 01:00, then product 101 and all successive product numbers must have at least the same or later date and time than the previous to be recognized).  I am still learning, but I thought I would share this if it helped the community.  Please correct me if I am wrong and Thank you again.

6
Configuration / Product controller error message
« on: July 09, 2016, 03:02:05 AM »
Help!  I am attempting to manually input products via the admin/products menu and now they are being assigned product id #0 and not showing up in the storefront.  I am getting the following error in my admin messages:

Error: Error in data of page with controller: 'pages/product/product'. Please check for key_value present where key_param was set

7
Installation and Configuration / Re: Import products from php feed
« on: June 26, 2016, 12:38:58 AM »
Thank you!  I believe that was the my error.  I truly appreciate the assistance! ;D

8
Installation and Configuration / Re: Import products from php feed
« on: June 23, 2016, 10:27:22 PM »
I did.  Our distributor sent us a large product export file in the form of a pipeline delimited (|) CSV file.  After reading the import/export documentation for AbanteCart, I manually created my first product, then was able to successfully export a CSV file, as instructed, to serve as my import template.  Was working with Excel 2010 at the time, although I just recently was able to upgrade to the 2016 Office Suite.  However, though it seemed I configured the CSV file for product importation according to the documentation (inserting the new column with "action" in the header row and "input" in the cells below), but I was never able to successfully import any products via the CSV file.  I did however, convert it to a .txt and changed the delimiter, seeming to finally achieve a successful mass product import.  I even confirmed that the additional rows/products had been added by browsing the associated products table in PHPmyAdmin, yet AbanteCart would not display the newly added data.  I've been manually entering products one at a time while I attempt to figure this out because deadlines are approaching, but we have a large inventory and it would save my countless hours of work to find a solution to this.  Thank you for your response!!

9
Installation and Configuration / Re: Import products from php feed
« on: June 18, 2016, 04:25:53 AM »
I have been having a hard time importing my product catalog data through AbanteCart's built-in importer myself...and by hard-time, I guess I mean no success at all.  This is my first eCommerce site and I like so many of the other features offered by this platform (I have version 1.2.7, btw, with a LAMP server set-up).  I am a novice when it comes to PHP and MySQL and I chose AbanteCart because of its' built-in data export/import features, but I haven't been able to successfully do either.

Pages: [1]

Powered by SMFPacks Social Login Mod