Failed to import supplier_id (spree_drop_ship)

[gitrepo4koresol]

Hi
We are using "spree-contrib/spree_drop_ship" extension.
This extension allows us to assign products to different suppliers.

We are able to upload products using datashift excel, but all uploaded products get assigned to "Spree Admin" user.

So, we mentioned "supplier_id" column within datashift excel, to assign products to specific "supplier", when we try to import this excel, this fails.

Please cloud you suggest the right way to assign "spree products" to specific "spree suppliers" ..

Thank you for your help!!

[autotelik]

hi .. does it fail with an error ? or simply fail to assign the id ? did you try just using 'supplier' as the heading ?

[autotelik]

by the way you can generate a template for a model's import, with all available associations, via

thor datashift:generate:excel -m Spree::Product -r spree_product_template.xls -a

[gitrepo4koresol]

Thank You very much for suggestions, using which we are able to make the progress ...
It's creating product record in database, even when we mention "suppliers" head and it's value in excel ...
But , now - it simply fail to assign the supplier id .to the product....

Please refer error log below, will appreciate your help =>

ActiveRecord::HasManyThroughNestedAssociationsAreReadonly: Cannot modify association 'Spree::Product#suppliers' because it goes through more than one other association

Cannot assign [#<Spree::Supplier id: 24, active: true, address_id: 197, commission_flat_rate: #BigDecimal:7f7971096d60,'0.0',9(36), commission_percentage: 0.0, email: "lorem@gmail.com", name: "lorem ipsum", url: "", deleted_at: nil, created_at: "2016-09-13 03:52:42", updated_at: "2016-09-13 03:52:42", tax_id: "", token: "rp_18t7yQAlxwPOUWS4XPhQ38t6", slug: "lorem-ipsum-da10a923-3a40-4f23-91e2-d9f879ac0d91", contact_number: nil, bank_name: "state", ..... LIKE MORE DETAILS ...]

(Array) to has_many association [suppliers]

[gitrepo4koresol]

Hi - Further digging of "Supplier" model class, we found below associations for "Supplier" - your suggestions to progress further will highly be appreciated .. Thank you !

class Spree::Supplier < Spree::Base
extend FriendlyId
friendly_id :name, use: :slugged

attr_accessor :password, :password_confirmation

#==========================================

Associations

belongs_to :address, class_name: 'Spree::Address'
accepts_nested_attributes_for :address

if defined?(Ckeditor::Asset)
has_many :ckeditor_pictures
has_many :ckeditor_attachment_files
end

has_many :products, through: :variants

has_many :supplier_variants

has_many :variants, through: :supplier_variants

has_many :shipments, through: :stock_locations
has_many :stock_locations
has_many :users, class_name: Spree.user_class.to_s

[autotelik]

I think the issue is Supplier is not actually directly associated with the Parent Product class. Its via the child Variant.

So perhaps a two stage load where you load the products then dump out all the Variants and assign suppliers to those variants (and run new load with -m Spree::Variant)

Or over ride the Loader, process method and write some custom code to process the Supplier column

for example of this over loading see
https://github.com/autotelik/datashift_spree/blob/master/lib/loaders/spree/product_loader.rb

or writing a specific loader from scratch

https://github.com/autotelik/datashift_spree/blob/master/lib/loaders/spree/shopify_order_migrator.rb

[gitrepo4koresol]

Hi - Sorry for replying late ...
Thank you for suggestions .. two stage load worked well ..
Thank You for your help!!