#1249 ✓resolved
dleffler

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

    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

    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

    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

    dleffler January 28th, 2015 @ 03:23 PM

    The shell/cron script is now included after a recent push

  • dleffler

    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.

New-ticket 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

Shared Ticket Bins

People watching this ticket

Tags

Referenced by

Pages