So, how to accomplish this? Here's what I see. It is possible at this point to export the detailed attributes from both store 1 and store 2. Each of these has text versions of the option names and option values names. For now, also eliminate from store 1 any row that doesn't have a model. Then begin moving entire rows as necessary such that the row in store 1 lines up with the row of store 2 by first comparing option names then option value names. Provided nothing "new" has been done with store 2, these should line up exactly with no editing.
Then once all have been lined up, copy the primary field data from store 2 over the data of the same field for store 1. Once all four columns are copied, save the file as the csv file to be uploaded and then imported into store 2. Obviously through this process you'll want to save a backup of the file s to minimize any rework. Keep in mind the filenaming convention needed by the plugin.
And with that, the new file when uploaded and imported to store 2 should cause store 2 to have the same attributes and details of attributes as store 1. Other attribute guidance: Currently the detailed attributes unlike the detailed product information for example are based on the specific database centric field record designations.
Excel will not necessarily do this, depending on your data, and the export CSV option you pick from within Excel, also dates and date formats may be revised by Excel and not readable upon import.
So a product with a dropbox of 3 colors will result in 3 lines of data exported. As you can see, there is a significant amount of data that is associated with attributes.
This functionality will only show when the appropriate version of stock by attributes SBA is detected to be installed to the cart. If SBA is not installed, then this functionality will not be presented and the remaining instruction regarding this feature can be skipped.
The file prefix has been set to: SBA-Stock-EP The two primary characteristics to consider when using EP4 are the columns headers across the top of the spreadsheet and the items being displayed. To explain, the headers from left to right offered by this feature are: 1. Model 2. Status product enabled or disabled 3.
Product Name in each language entered shifting the remaining columns to the right. In each language entered shifting the remaining columns to the right. If potteryhouse's version of SBA is installed or the customid field exists in addition to some other fields then this column will have the customid, otherwise, all of the columns below will move left to replace what would be in this column. Whether the item listed in the row is tracked by Stock by Attributes SBA using a marker if yes and leaving the row's field blank if no.
A unique identifier associated with the data type of item in the row. OptionName1 may be the same as OptionName2 and still will be listed as shown with a different OptionValueX at each entry. The quantity of the item in the row. Item 7 of the list was abbreviated to simplify the explanation. These values are provided to support import of the data and they should not be revised for normal operation.
The position of the column was chosen to not place it adjacent to a field that is likely to be changed by the user. Technically for EP4 to import this new file, the only columns important for the import are the ones located in items 6, 7 and 9, all of the other columns were provided to help the individual performing the stock inventory identify the product s.
Ideally, column 7 would not exist and instead the program would determine the appropriate value for that column based on other information in the table so that the spreadsheet would not be dependent on the current database but could be applied to any database at any time.
This will require a revision to accomplish. This brings us to the arrangement of the rows. Every row of data has the potential of having attributes associated with the product, but every product has a quantity associated with it. Below are two examples 1 of a product without attributes, the other with attributes as described. On export, every product will be listed, whether an active product or not. If a product is tracked by SBA, then the product's data will be provided as the first row for that product, followed by rows of the SBA associated data.
So if a product has two option values green and blue for a single option name Color but is not tracked by SBA then in the row for that product the attributes column item 7 of above and quantity item 8 of above assuming 70 of this product will show as: Product has no attributes: Attribute s Quantity 70 Product has two attributes 2 option values, but one option name : Attribute s Quantity Color: green;Color: blue 70 If a second product had the same attributes with 70 total, but 40 were green and 30 were blue tracked by SBA, then the export would be something like: Product has two attributes and both are tracked by SBA: Attribute s Quantity Color: green;Color: blue; 70 Color: green; 40 Color: blue; 30 There are two links available for import.
One that imports all of the data as entered Import Import of the below followed by export would provide the below it would be considered acceptable and left as is. The other imports the data, but then synchronizes the total with the sum of the SBA tracked quantity. Import of the below followed by export would provide the above. Product has two attributes, both tracked by SBA but total quantity exceeds the sum of each: Attribute s Quantity Color: green;Color: blue; 85 Color: green; 40 Color: blue; 30 The first example applies to the display of every product in the database: - If a product does not have attributes, there is a total quantity of the product.
The same could be said for the green and blue options if the green and blue attributes had an unlimited supply, say if a marker is used to add a green stripe or a blue stripe. The number of stripes is more dependent on the age of the pen, the quantity of ink and the time available of those applying the stripe than the number of products that already have the stripe.
So that product may not be tracked by SBA. The data of the second example is similar to this situation, or if the product has not yet been entered to be tracked by SBA. One is the total number of the product, the other is the number of the product that has the specific attributes being tracked: ie, quantity 5 of a 10" diameter ring, made of silver, with a blue pendant as compared to quantity of 6 of a 5" diameter ring, made of stainless steel, with a green pendant, and all the variations of these options.
So in this case, the data provided in the exported file would be similar to what was provided in the third example. The first row shows the total number of the product and all possible attributes, each subsequent row shows the specific quantity of the product having the assigned attribute s. That said, it still "follows" the same ZC process.
First the product must exist, and as part of "creating" the product, it must go into a category. Then, to apply attributes, the attribute s must exist attributes basic , then the product is populated with the attribute s attributes detailed.
If you want to delete a product, then set the status of the product to the number 9. Understand that this will completely remove the product from the store, not just disable it status of 0. The Easy Populate contribution comes complete with installation instructions. Step by Step instructions on how to install the contribution. As far as contributions go, that's more than average documentation. See my Profile to learn more about add ons, templates, support plans and custom coding click here.
Find your administration directory and you will need to put easypopulate. Virus Threat Scanner. My Contributions. Basic install answers. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. I followed the directions in the download for EasyPopulate 2. I signed into oscom admin and the link to easy populate appears properly under the "Catlog" link.
Albeit in French, I found someone with the same problem here. Don't know if anyones following this thread still? Maybe I keep hitting the wrong discussion or I have looked too hard and long and have temporary osc blindness but, if anyone knows if the latest version of this contrib works with v2. Im trying to use latest version and it seems to be updating all my prices incorrectly then doing nothing with decsriptions and the like.
You need to be a member in order to leave a comment. Sign up for a new account in our community. It's easy! Already have an account? Sign in here. Sign in to follow this Followers 0. Recommended Posts.
0コメント