Magento Multi Source Inventory, 8 Dec 2017

Previous Meeting Next Meeting

⏯

youtube image

►

From YouTube: MSI Open Demo. December 8, 2017

Description

- @Yaroslav Rogoza - Low Stock Notification Story (admin UI part)
- @Bartłomiej Szymański - Basic Checkout Integration
- @Bartłomiej Szymański - Migration of CatalogInventory Stock Data to MSI

A

So hello, guys today, is our traditional msi weekly demo and we have- and we have pretty interesting agenda for today and we will have something to show you. The basic Scout integrations the basic migration from the Gaelic inventory to the msi data and the UI of the backend part for the lost or quantity story. So, according to the agenda, Yaroslav ragazza will start the demo and will show his update on the lost or quantity story there so feel free to share your screen.

B

B

So in the previous demo we have introduced the inventory configuration extension. It's a separate extension that represents the configuration of the stock items in the legacy version. We have the configuration, alongside with the values like we have.

B

We have quantity, we have quantity value, alongside with the configuration with the backorder with lost or congressional sat in one database database table. But and now we decided to separate this- and we have two modules for this purpose. It's in under configuration module and the inventory configuration API module in order to here to be able to use it from other modules, and now we can use them functionality.

B

So, for example, if we create some new product.

B

Let's, let's go to a world and science and quality and we have an additional. You are in the face for assigning a source for the product. Sorry.

B

So we can source and assign some quantity, and we have checkbox prone default quantity at this moment, but the functionality is not realize it's not implemented yet, but as as we represented in the previous demo, if them a product is not a specific configuration for current product will use the ration from that.

B

We we are: it's not necessary to implement like configuration for every product operation for a specific product. It will be retrieved from them from the default interaction, so we can use.

B

B

And in the inventory source island configuration table well reassurance for that specific product, they have a superstar D s, clue and little quantity and I have specified the default values it's zero moment and it's represented in that.

B

So that's all at this moment. Thank you and.

A

Just so I believe we, so the next step would be actually like make the notification of working and adding the check for the all talk and the email notification form erosion weather. We get through the threshold specifying the admin panel.

B

Yeah, that's right, so the lowest out notification will be a separate module that we are going to develop further, so the module will check their configuration from the table and then lo stuckness notification will be applied regarding the value from the from the notify low stock table yeah. Thank you. Okay,.

A

Cool, thank you. Okay, the next presenter, according to our gender is Bartok, and the Bartok will show you the basic integration, the catwalk inventory and finality with the MSI functionality. Bartok feel free to share us.

C

Ok, hello, guys.

C

Do you see my screen? Yes, ok! So.

D

Let's start from.

C

Basic integration in check out I have made some preparations for this.

C

I use reorder functionality to make an order, owns, specified simple product 122 in that case, and I choose 5 as needed, quantity and proceed to checkout.

C

Meanwhile, I show you a back-end found out of the simple product and you can see there is a presentation of old inventory stock ITER which now is set to 95 and the same is a new MSI source item. Quantity is equal, so what's left leg to the checkout.

C

Okay, quick next and yes, this is my product in the place in order.

C

Okay, thanks for portions and after refreshing that port.

B

Representation.

D

C

Old cattle in the first item is decreased by 5, which are ready and buy, and also the new feature. The new MSI source item quantity, equal to the ultra BC quantity. So the first basic integration where.

C

Old catalog inventory item.

C

When decrease its quantity.

D

C

Same is happening on umsi source item quantity, so this is for for check out the charm and also when we change of quantity in the dashboard, safe dot product, the new MSI quantity.

C

But my touch parties, we got okay and you can see that quantity on source item in different source also change the same quantity. Okay. So let's move to increase in data and I show you.

C

Some some feature to.

D

C

C

When refresh page.

C

You can see that that's in the database exists only old continental title new inventory is not yet returned, so this is a simple.

C

Simple way to show you how agent will work when you great from production to new one which is I, am bored so.

C

Now I set up a great when this.

C

You know this old catalog inventory stock item. It's been waiting to the new MSI.

E

Particle simply sharing terminal right.

E

This is me sorry, we here where we see a man: okay, okay, yeah,.

C

Because there's starboard so di and all our static files is generating right now so take away.

C

Okay, so, as you can see, after immigrating, tiful source is set to the old quantity from alt, even first item, and the same is happened when we use simple data when we hit so simple that our own fresh style, and so that's it.

C

A

You thank you Bartok, for the great meditation can you can I also just please to show you one more thing which I believe Antone or maybe other guys would be also interesting. How how.

D

A

Migrate, the data all the installation to new one and yes, I- know that you made some performance and maybe my grade 1 million direction. Can you just just share of that background? Yes,.

C

Of course, so I share my my PHP store.

C

C

C

Take place during the installation or during ordering immigration from one version to the higher version, with msi on the board and there's iteration.

C

Which executes which epic used plain SQL queries the database, it simply in simply run insert insert from select and that's it. I tested the few mention before / 1 1 million records of inventory of inventory, and this is about two minutes to complete immigration and also index that all data. So all the functionality is.

C

This is the rest world. First.

A

In key Bartok, Thank, You Anton, maybe you'd have other questions.

E

The only question is you decided, yeah I like the migration is very fast, but one of the problems with insert from select will be custom implementation, but it gets hairy. We discussed this problem or the options of using API.

A

Way too big your phone on throwback using the API migration? That's why we ended up using the insert from select sorry.

D

Great mask additional collation, characters to dissolution Museum come with them come extension. As I know they made some.

A

D

A

And the guys from M Coney, you actually stock item Cadillac inventory underscore stock underscore we use them but like because they also have some additional voltage I believe they probably they could need to introduce some migration additional Negros. Well,.

E

I think one option for this- something we can add to backwalk an option implement would be separate migration to or separate different migration strategy, that would, it would be much slower additional command or implement here we can think about it that will do migration using API so that people not have to write.

E

D

We can do in the same way how it was made for b2b and surprise inputs. We can just introduce a new API for this and just change. It.

D

Yes, we see situations that we need to have a bulk API for the stock. I saw the same issue with the clients. Real clients integrations.

A

You API for legacy code is a good idea because we need to introduce this new API, not this MSI could but for the legacy. Fourth, so we will just introduce it and mark it as a duplicated, because it's gonna it could be eliminated in the next measuring.

D

Okay, sure, okay.

E

So, anyway, what what but do this notation, affine wiki page, do we have more things to demo it, but just remember to discuss a special okay.

A

No probably know because one of our presenter had a has a flu, so it's a problem with his voice, so I believe upon his demo until until next magenta. So we will use that time, we'll use a time to say happy birthday to our our chief architect, Anton cream and the congratulate all the best.

A

E

A

Okay, so if there are no any other questions, thanks for the participation and your 10 tension and attendance and see you next time, thank you.

E

Thank you. Thank you guys. Thank you. Thank you.