These are chat archives for reactioncommerce/reaction

10th
Feb 2017
sam stein
@samhstein
Feb 10 2017 00:51
@zenweasel thats where im a bit confused... usually a variant has multiple attributes like size, color so if you have a shirt with 3 sizes in 5 colors u would have 1 product with 15 variants each with its own price, cost, sales price, inventory
Brent Hoover
@zenweasel
Feb 10 2017 00:56
yes, the terms may be a bit confusing but “product”/“variant” and “option” are all the same type of “product” record
if you look in the db for the default install you can see this
how they exist in the hierarchy is defined by “ancestors"
sam stein
@samhstein
Feb 10 2017 01:00
yep, see that and like it, but am not getting where there are 15 different inventories are as it seems to capture qty on the single variant level. ie: there are no red shirts without a size
Brent Hoover
@zenweasel
Feb 10 2017 01:00
Robomongo_0_9_0-RC9.png
I think what may be confusing is that there is an inventory record for every single item. And by that if you only had 10 Red Small t-shirts in stock and nothing else, you would have 10 inventory records
sam stein
@samhstein
Feb 10 2017 01:03
i do c the inventory table, was expecting a qty... so if there are 5000 skus with 200 pieces each there would be 1M records in the inventory table?
Brent Hoover
@zenweasel
Feb 10 2017 01:03
correct
each record has a “workflow” that shows what it’s status is
sam stein
@samhstein
Feb 10 2017 01:05
like new, sold, gone, whatever?
Brent Hoover
@zenweasel
Feb 10 2017 01:05
correct
sam stein
@samhstein
Feb 10 2017 01:05
has it been tested with a decent size sku / inventory for performance
we do have 1M+ items
Brent Hoover
@zenweasel
Feb 10 2017 01:07
Yes, I’ve tested it with SKU sets in the 10’s of thousands. It doesn’t cause any issues on the customer side. Mostly because it’s never really directly exposed to customers. It can bog down the admin side.
We have a scheduled ticket to alleviate that: reactioncommerce/reaction#1370
sam stein
@samhstein
Feb 10 2017 01:12
makes sense, pretty common to keep the current inventory with the product, and just use your current table as a history of inventory items... although i'd guess most add a qty to your inventory model to allow for multiples to be added / sold
not sure that when u add 10 to an item that creating 10 records gets u much
Brent Hoover
@zenweasel
Feb 10 2017 01:13
I think we tried to make the inventory plugin as stand-alone as possible, thinking that many people will want to create their own and remove ours. Inventory is one of those things that changes a lot from business to business
sam stein
@samhstein
Feb 10 2017 01:13
agree, we will replace / talk to the erp
Brent Hoover
@zenweasel
Feb 10 2017 01:13
that’s why it’s mostly implemented using Hooks
sam stein
@samhstein
Feb 10 2017 01:13
nice
Brent Hoover
@zenweasel
Feb 10 2017 01:14
Yeah, there are definitely advantages and disadvantages to this approach
sam stein
@samhstein
Feb 10 2017 01:14
i'll dive a bit more into the products, c if i can figger out how to import products / variants from woocommerce as a test
Brent Hoover
@zenweasel
Feb 10 2017 01:15
Ok, I believe GetOutfitted created a CSV import module that’s pretty cool if that helps
you’re doing a million SKU’s on WooCommerce?
sam stein
@samhstein
Feb 10 2017 01:16
not skus, items
Brent Hoover
@zenweasel
Feb 10 2017 01:16
so tens of millions of SKU’s?
sam stein
@samhstein
Feb 10 2017 01:17
other way, 5k - 10k skus, each with inventory
some pants have a couple hundred variants
Brent Hoover
@zenweasel
Feb 10 2017 01:18
gotcha
sam stein
@samhstein
Feb 10 2017 01:18
thats why i need to understand the way options work, like shoes have: size, color, width
would be nice to reuse the size, color, width collections across products, styles
Brent Hoover
@zenweasel
Feb 10 2017 01:19
Yeah, that’s a weakness we have right now. You’re going to need to create a record for size 21 - 42 etc. for every color, etc.
sam stein
@samhstein
Feb 10 2017 01:20
is there a link / github for the csv import
sam stein
@samhstein
Feb 10 2017 01:22
thx, maybe i'll tackle enhancing the options... should really just be another model and hash of options in the product like: productOptions {id, id, id}
Brent Hoover
@zenweasel
Feb 10 2017 01:23
yeah, with Mongo we shy away from doing too many related objects
it’s like storing JSON in a SQL db. You can do it, but it’s not what it’s built for
sam stein
@samhstein
Feb 10 2017 01:23
understood, rails background is showing ;-)
Brent Hoover
@zenweasel
Feb 10 2017 01:24
yeah, totally get it.
sam stein
@samhstein
Feb 10 2017 01:24
gotta b able to bulk generate variants from options if your gonna run a real retail site in my world
Brent Hoover
@zenweasel
Feb 10 2017 01:25
yes, you’re not the first person to bring that up
sam stein
@samhstein
Feb 10 2017 01:25
but maybe we can just do all the product managment in the erp?
Brent Hoover
@zenweasel
Feb 10 2017 01:25
that’s one option. Especially if that’s really where you work
what ERP are you using?
there seems to be a rash of ERP talk lately
sam stein
@samhstein
Feb 10 2017 01:26
not sure yet, prolly erpnext or tryton
Brent Hoover
@zenweasel
Feb 10 2017 01:26
right, that was you I was talking about with. ;)
sam stein
@samhstein
Feb 10 2017 01:27
both have decent apis to get / set data and docs
Brent Hoover
@zenweasel
Feb 10 2017 01:27
yeah, we’d like to see a couple of good ERP and POS integrations
sam stein
@samhstein
Feb 10 2017 01:28
keep your fingers crossed were prolly gonna try it
is there good docs on the hooks
Brent Hoover
@zenweasel
Feb 10 2017 01:30
Yeah, doc site is not loading for me at the moment. Or at least the TOC isn't
If you look at the inventory plugin, it’s fairly straight-ahead and tbh probably a little immature.
but for simple stockkeeping it should work
sam stein
@samhstein
Feb 10 2017 01:34
k, wondering about using a hook for products, or maybe just treat it as a product cache that gets refreshed with a big chunk of json when needed
Brent Hoover
@zenweasel
Feb 10 2017 01:34
just depends on how “real-time” you need to be I guess
sam stein
@samhstein
Feb 10 2017 01:36
could prolly keep things pretty sync via rest, and then refresh the world nightly
Brent Hoover
@zenweasel
Feb 10 2017 01:37
if it’s all going to be in your ERP that would make a lot of sense
sam stein
@samhstein
Feb 10 2017 01:37
thx for all the help, will do some testing, check and be back soon....
Brent Hoover
@zenweasel
Feb 10 2017 01:37
:+1:
Dominik
@domi-nik-
Feb 10 2017 14:48
@samhstein I would be interested in a product importer of woocommerce, if you've got something please let me now. :)