Differences between revisions 11 and 28 (spanning 17 versions)
Revision 11 as of 2017-08-14 04:24:46
Size: 1474
Editor: thog
Comment:
Revision 28 as of 2019-05-13 00:20:07
Size: 2566
Editor: sam
Comment:
Deletions are marked like this. Additions are marked like this.
Line 4: Line 4:
http://apparel2.crecom.com.au [[http://apparel2.crecom.com.au|http://furniture2.crecom.com.au]]
Line 8: Line 8:
http://apparel2.crecom.com.au/administrator [[http://apparel2.crecom.com.au/administrator|http://furniture2.crecom.com.au/administrator]]
Line 12: Line 12:
password: c0ntr6l password: control1
Line 14: Line 14:
| == Create attributes and attribute groups ==
Go to Stores->Product (make sure type is dropdown, and set global in advanced)
Line 16: Line 17:
| Go to Stores->Attribute Groups
Line 20: Line 21:
'''0. mark sure '''dumpodbc and impmagord is not running in the background. use "initctl list" and "initctl stop dumpodbc"
Line 21: Line 23:
run "gencont" in "Ecommerce" tab, make sure the attribute settings are like following:

attachment:magento2Attribute

1. use "gencont" and "condisp -c -b" to make sure you are in the right branch and company.
1. use "coaad" page 2,"braad" online,"gencont" online, "coxaad" online ord id and "condisp -c -b" to make sure you are in the right branch and company. also you can "export SCRIPT_ID=$NODEID" to make sure the log2magento program won't be affected by the false errors.
Line 29: Line 27:
3. clear the online ID for Stocks: "sturep" -> E -> 6 -> "your branch" -> "your branch" -> N -> N -> N -> hit enter -> hit enter -> hit enter -> hit enter 3. clear the online ID for Stocks: "sturep" -> E -> 6 -> "your branch" -> "your branch" -> N -> N -> N -> Y -> hit enter -> hit enter -> hit enter -> hit enter
Line 31: Line 29:
4. clear the online ID for Categories: "catrep" -> E -> S -> Y -> Y -> N -> hit enter -> hit enter -> hit enter -> hit enter 4. clear the online ID for Categories: "catrep" -> E -> S -> <leave_blank> -> Y -> N -> hit enter -> hit enter -> hit enter -> hit enter
Line 37: Line 35:
7. "log2magento -C" to dump the categories to the magento 2 server. 7. "log2magento" to dump the categories to the magento 2 server.
Line 41: Line 39:
9. "fdb2log -B <your branch location> -a9" 9. "fdb2log -B <your branch location> -a9" (remember the number of the stock items!; '''ALSO the images of items could NOT be .bmp type.''')
Line 43: Line 41:
10. "log2magento -C" to dump the stocks to the magento 2 server. 10. "log2magento" to dump the stocks to the magento 2 server.
Line 47: Line 45:
!!!! KEEP CHECKING the stock numbers in the MAGENTO server. IF the magento server's stock number is not increased for 10 mins and the stock number is the same as the stock number which is generated by step 9. We need to manually kill the log2magento process.
Line 48: Line 47:
'''Setup the automatic magento <=> control scripts:'''
Line 49: Line 49:
check /etc/init/dumpodbc.conf and /etc/init/impmagord.conf, make sure they are conset to the right company and location.

1. initctl list (make sure dumpodbc and impmagord is not running)

2. initctl start dumpodbc

3. initctl start impmagord
Line 52: Line 59:

support@creativecomputing.com.au
11QQaa!!
support@creativecomputing.com.au 11QQaa!!

MAGENTO2 Integration Info:

Our Internal Magento2 server is:

http://furniture2.crecom.com.au

Admin page:

http://furniture2.crecom.com.au/administrator

admin login: support

password: control1

Create attributes and attribute groups

Go to Stores->Product (make sure type is dropdown, and set global in advanced)

Go to Stores->Attribute Groups

Re-import Stock and Categories from Control to Magento2 Database:

0. mark sure dumpodbc and impmagord is not running in the background. use "initctl list" and "initctl stop dumpodbc"

1. use "coaad" page 2,"braad" online,"gencont" online, "coxaad" online ord id and "condisp -c -b" to make sure you are in the right branch and company. also you can "export SCRIPT_ID=$NODEID" to make sure the log2magento program won't be affected by the false errors.

2. "log2magento -i" to delete the stocks and categories in the magento. And confirm the stocks and categories are deleted from the magento in magento web page.

3. clear the online ID for Stocks: "sturep" -> E -> 6 -> "your branch" -> "your branch" -> N -> N -> N -> Y -> hit enter -> hit enter -> hit enter -> hit enter

4. clear the online ID for Categories: "catrep" -> E -> S -> <leave_blank> -> Y -> N -> hit enter -> hit enter -> hit enter -> hit enter

5. "cp $CCDIR/standard/dblog.dat $CCDIR/<your company>/"

6. "gol" -> "fdb2log -B <your branch location> -a8"

7. "log2magento" to dump the categories to the magento 2 server.

8. "cp $CCDIR/standard/dblog.dat $CCDIR/<your company>/"

9. "fdb2log -B <your branch location> -a9" (remember the number of the stock items!; ALSO the images of items could NOT be .bmp type.)

10. "log2magento" to dump the stocks to the magento 2 server.

//

!!!! KEEP CHECKING the stock numbers in the MAGENTO server. IF the magento server's stock number is not increased for 10 mins and the stock number is the same as the stock number which is generated by step 9. We need to manually kill the log2magento process.

Setup the automatic magento <=> control scripts:

check /etc/init/dumpodbc.conf and /etc/init/impmagord.conf, make sure they are conset to the right company and location.

1. initctl list (make sure dumpodbc and impmagord is not running)

2. initctl start dumpodbc

3. initctl start impmagord

Magento 2 Account info (for upgrading and buying with private/public keys):

support@creativecomputing.com.au 11QQaa!!

Magento2 (last edited 2025-10-02 03:12:46 by KafuWong)