Search results

Ok....let me ask first. Did you catch the part that I am attempting to re-create what I created in ACCESS in SQL now? Trying to discern where you are lost at.

Hello everyone...hope all is well....so I recently went from ACCESS to SQL in trying to accomplish my task. Problem is I never used SQL before and it's going very slow....I had help writing a query/script that solved my previous learning curve, but no need to figure it out in SQL and...

That's why I was hoping s Someone could come up with something.....

That was my original path. I won't be selecting sizes as I will be importing files with predetermined data that I have to the format for my use. I was hoping something a little more automatic such as a table with ranges and a dlookup function to search and retrieve??

So i'm trying to come up with the best method to create a "Size" table for rugs.....there are only 7 options that any particular sized rug must be categorized in and the value of one of the 7 options needs to be returned. What would be the best way to create this lookup table with so many...

Think of it like this! You create folders/paths to categorize or configure simple records to then get filed into within Magento......Simple/children are created first and off the simple/children records you then create different categories that you set/create folders within Magento. When you...

2 other fields that are from a configurable record related_position related_skus 1,2,3,4,5,6,7,8,9,10...

Here is configurable_variations field configurable_variations sku=0053100486024036IP,custom_sizes=2'0" x 3'0" Runner,display=0|sku=0053100486060096IP,custom_sizes=5'0" x 8'0" Rectangle,display=0 sku=0053210022024036IP,custom_sizes=2'0" x 3'0"...

Absolutely agree, so the question becomes for me anyways with my lack of knowledge and expertise......is there a tool out there that can do this? Or does it need to be done on a field basis......This is just one field...here are examples of what the other results need to be....here is what the...

If it was done, I wouldn't be asking another question....lol........Yes, no it isn't done.....if you have any positive input, i'd appreciate listening to it. Thanks

Great help, thanks

which extension do you recommend so I can find it and then attach. Tried a few, but only .pdf worked.

I just looked at the file I attached in .pdf format....i deleted, hard to read. Is there a way to attach a .csv file?

I don't blame you....lol.........Yes exporting & importing is not the issue. Also, what kind of Indian you sporting!!! I just added an example. I attached a file in .pdf format, wasn't able to attach a .csv?

Sure Isaac: This link https://docs.magento.com/user-guide/catalog/product-create-configurable.html explains what a configurable record is and they show how it's created using Magento. I need to know how to create it outside of Magento using access.

Working on creating a process within Access to then export into a .csv file and upload into Magento 2. I have searched and searched for a tool to help create the configurable records by using the simple records outside of Magento, but no luck. Anyone here have any knowledge on what the best...

That is perfect! So the only thing i'm not really understanding is the VBA....what do you recommend I read to get a better understanding of structure and functions, so I can better understand your VBA Module? I will try to add the queries to my database which will be easy. I'm not sure how...

Exactly! It doesn't exist and is created by grouping the simple records. So if there is one simple record, one Configurable gets created off that one simple record. If there is 10 simple records and the 1st two data parts of the SKU then creates the configurable with all the different...