Feature request: tweak 'import products'
Reported by dleffler | December 27th, 2014 @ 01:40 AM | in 2.3.3 (closed)
Though 'Import Products' works, it isn't robust and has many limitations such as no documentation and requires a rigid csv format. Would be nice to be able to use it to not only add products, but to update existing products (would lean heavily on the SKU). Not sure we could do all these things, but some options might be:
- need to tweak 'export products' to create a 'shell' file to be used for import? We currently don't provide a link though the method exists
- add and update products based on SKU (would require ALL products have an SKU, since we couldn't rely on a product 'id' which is the current method)
- url to product 'image'...we have to curl the image, add it to expFile, etc...
Current csv format (based on the code) is
0= id
1=parent_id
2=child_rank
3=title
4=body
5=model
6=warehouse_location
7=sef_url
canonical isn't in import at this point
8=meta_title
9=meta_keywords
10=meta_description
11=tax_class_id
12=quantity
13=availability_type
14=base_price
15=special_price
16=use_special_price
17=active_type
18=product_status_id
19=category1
20=category2
21=category3
22=category4
..
30=category12
31=surcharge
32=rank
33=feed_title
34=feed_body
Comments and changes to this ticket
-
dleffler December 27th, 2014 @ 11:25 AM
We introduced a regression bug a few versions ago when we activated module item import/export which prevented importing products. This was fixed in the develop branch with a very recent (post v2.3.2) code push.
- we already can create a 'shell' csv file using e-commerce, reports, build a product report, and then export products to csv
- we also might want to allow adding a 'manufacturer' field?
- we also might want to allow weight, height, width, etc...?
- we might want to 'import' based on heading line or assume it's this current format
-
dleffler December 31st, 2014 @ 02:00 AM
We might want to add a cron script to be able to run product (inventory) updates automatically
-
dleffler December 31st, 2014 @ 09:44 PM
locally have code for export/import weight, width, height, length, and manufacturer (companies_id), with optional import of main image and up to 4 additional images via url downloading.
Still would like to add
- shell/cron script to import csv file
- use a field mapper like we do when importing users or forms to match csv fields with product fields to allow for smaller csv files (now we MUST have all the fields in place since we reference them by index #)
-
-
dleffler January 30th, 2015 @ 02:30 PM
- State changed from “new” to “resolved”
Recent update adds auto-mapping based on csv file header matching 'product' field, also allows matching sku/model in addition to product id
Please Sign in or create a free account to add a new ticket.
With your very own profile, you can contribute to projects, track your activity, watch tickets, receive and update tickets through your email and much more.
Create new ticket
Create your profile
Help contribute to this project by taking a few moments to create your personal profile. Create your profile ยป
Bug Tracker for Exponent CMS
dleffler
expNinja
Tags
Referenced by
-
1248
Feature request: add product inventory import (export?)
We can do this with import products, so we'll move this t...